Goto the top of a spreadsheet???

[OrangeHead]

This might sound simple but I can't find an answer ANYWHERE!!! I am writing a macro that pastes information to various locations in a spreadsheet.

What I would like to do is programmatically tell the macro to goto the firstrow on the sheet within the active column. The best I have found so far is this ActiveWindow.VisibleRange(1).Select which does almost exactly what I want -- The only problem is it specifies column 1 rather than the column I happen to be in. Can anyone help with this?

 

[RoryA]

Activesheet.Cells(1, activecell.column).Select

Note that it is almost always unnecessary to select anything in code.

 

[Andrew Poulsom]

Try:

Cells(1, ActiveCell.Column).Select

 

[OrangeHead]

Thanx Gents!! I owe you one