Go to column a of active row

[DrSmyth]

Hi,

I've got a spreadsheet that uses activecell and offset to populate a word form with data that's been entered into the spreadsheet.

The problem i have is that i need to insure that when the code starts running column a is selected.

Is there a way of forcing the cursor to column a of whatever row is currently selected?

Dr

 

[xlbo]

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

should do the trick nicely

Rgds, Geoff

 

[DrSmyth]

Cheers, that has to be the quickest response to a query ever...

Andy

 

[TropicalFred]

How about:

Range("A" & ActiveCell.Row).Activate

-Fred