Excel Macro VB Syntax Question

[EUROWINGS]

Hi guys,

I try to upgrade one of my macros, but I can not seem to find the right syntax.

The function, I like to automize, is analogue to pressing the "Pos 1" button.
I would like the active cell to be in the same row, column 1.
What would be the appropriate syntax within the macro?

Thanks a lot,

cheers,

Andreas

 

[Loomah]

If I understand you requirements correctly, something like

Cells(ActiveCell.Row, 1).Activate

will do the trick

;-) If a man says something and there are no women there to hear him, is he still wrong?