Select row: row number determined by a variable 1

[artsandcraftshome]

I need to select a row in a worksheet where the row is determined by a variable..
rows(variable:variable).select does not work.
I am using Cells(variable).select, with the column number set to 1, but then the row selection goes away when I move to the right in the spreadsheet.
Any suggestions would be much appreciated.
thanks
Johnny

 

[Loomah]

Hi
rows(variable).select should do the trick
or cells(rowvariable, columnvariable).select
or cells(rowvariable, columnvariable).entirerow.select
should also work

obviously the variables need to be of the type integer or long but......

;-)

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