Like DocAElstein suggested. Explain in detail.
But also:
In "Sub UnmergeAllCells()" you reference ActiveSheet
In "Sub UnwrapTextAllCells()" you don't reference any sheet.
In "Sub...
Type: Posts; User: jolivanes
Like DocAElstein suggested. Explain in detail.
But also:
In "Sub UnmergeAllCells()" you reference ActiveSheet
In "Sub UnwrapTextAllCells()" you don't reference any sheet.
In "Sub...
@Admin
Kimi is doing better in Singapore.
Could not fing anything for him though.
ok, thanks for the kind words and we'll leave it at that.
Keep on "duimen voor Max Verstappen"
Indeed. I stand corrected.
I guess instead we could use Trim
My apologies snb.
I don't know if you tried snb's formula but if you found that it does not work it is because you need to change the semicolon (;) to a comma(,).
You might also take his counting with a grain of...
You could try this
Range("A" & Rows.Count).End(xlUp)(-498).Resize(500,6).Copy Range(H1")
Range(Cells(5,1), Cells(Rows.Count, "A").End(xlUp)).Resize(,11).Select
This should replace the two lines of code. Select is very seldom needed and you should see if you can adapt the code.
Using...
The data is the result of the formula, so no, you can't
Clear the values in Columns B and C and use this Formula.
=IF(OR(B3="",C3=""),"",SUM(B3:C3))
An ugly way of getting there.
Cell A1 has the starting number
Cell A2 has the end number
Cell A3 has the increment
Column B needs to be empty (free to use)
Result in cell E2
Sub...
Have a look here
Code for Trim Non-numeric values..