If not numeric

[Luapo]

I would like to know if its possible to have an If statement saying something like this in VBa

If the active cell is not numeric (or is alpha, doesnt matter which) Then

move the active cell to the right one square

end if

Thankyou very much

 

[Luapo]

I am looping down a column using offset so i can copy and paste the individual cells to another sheet. However i am using this in a do until loop, because the numbers in the column can change.

where the until condition is when it reaches a blank cell it stops.

But some columns are full and others have gaps. So i just wanted to find the value of the bottom cell, take the row number and then use that as a place to stop for the columns with gaps in the data.

That is all.

EDIT: sorry i took so long to post, im a slow typer.

 

[Zack Barresse]

To find a bottom-most cell in a column...

myVar = Cells(Rows.Count, "A").End(xlup).Row

Try not to use 65536 rows anymore (if you know what that means) in lieu of what MS is doing ... http://blogs.msdn.com/excel/default.aspx

 

[Luapo]

Ok, thankyou very much for your time.