VB to find & positioning on first blank cell

[carlosmaldonado]

Dear Sirs,

I don't know almost anything about VB, but I need to manage a way of create a macro, to find and positioning the cursor in the first blank cell, down the column A, by analyzing all the columns from A to AK, and detect the last non blank cell in any of those.

Could I count on your expertise?

Beforehand thanks for the help.

Carlos Maldonado

[stnkynts]

I think this is what you asked for. This will select the first blank cell in column A and will tell you what the last non blank cell in A is:

Please Login or Register  to view this content.

[MarvinP]

Hi Carlos
The VBA to find the last non blank in Col A only looks like:

Please Login or Register  to view this content.

If you need to find the last in columns A to AK (AK = Column 37) then try:

Please Login or Register  to view this content.

You will need to add 1 to the last statement to get the first blank row as in:

Please Login or Register  to view this content.

[carlosmaldonado]

Hi stnkynts,

first of all thanks. Your input tells me where the last cell in the A column is, but what I need, instead is to positioning the cursor over there, to start to fill the file w/o having to scroll down evrytime I want to get there. Is that possible?

Thanks
CM

[stnkynts]

There are many ways you can do this. Just to make sure i understand correctly you want to select the row after the last row with data in it. Something like this should work just fine:

Please Login or Register  to view this content.

[carlosmaldonado]

Dear Marvin,

you're a pro! You've interpreted correctly my problem and managed a 100 % useful solution! Brilliant!

Many thanks

[carlosmaldonado]

Hi stnkynts, anyway thanks for your help.

Regards
CM