Move to column "A" in a row with VBA?

[luporiman]

Hello,

I'm a self-taught VBA user. I am trying to figure out how to stay in the same row, but move to column "A", regardless of what column I am currently in.

I don't think I can use the ActiveCell.Offset() command because I need to move a variable number of columns.

Any help will be greatly appreciated. Thanks!

 

[TheNoocH]

welcome to the board...

not sure what you are trying to do...this will refence column A of the current row you are in...if that's not what you are after post some of your code and point out where it's not working

cells(activecell.row,"A").value

 

[Richard Schollar]

Hi & Welcome to the Board!

Perhaps:

Activecell.Entirerow.Range("A1").Activate

or:

Cells(Activecell.Row,"A").Activate

 

[luporiman]

I am getting debug errors when I try your suggestions (not sure if it is notable that I am useing Excel 2003).


I started with the code below, and my goal is to have my next line of code move me to cell D4, regardless of the column I put into the range command.


Range("D1").Select

ActiveCell.Offset(3, 0).Select

(Line of code that will moce me to column A regardless of current column)


This is part of a much larger macro where my ultimate goal is to copy data from one file (improperly formatted) into another. I need the macro to start copying data into column A of the next row when it encounters a certain text string.

I think I can pull that off if I can successfully change columns within the row.

 

[TheNoocH]

if you just want to move to column A based on the row you are in then Richard's code should work just fine

Cells(Activecell.Row,"A").Activate

but if you are just moving to copy something there then there is probably an easier way...also in your code above doing the .Select on cells is normally not needed...

 

[luporiman]

I right-clicked the yellow line of code and asked for the "Definition", and the message I got states:

"Can not jump to active cell because it is hidden"


I don't have any hidden cells in the worksheet, so I'm not sure what to make of that.

 

[luporiman]

So, I closed the sheet and re-opened it and now the code is working.

I can't thank you guys enough for the help!