View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_9_] papou[_9_] is offline
external usenet poster
 
Posts: 52
Default How to Select a Row in VB Macro

Hi alan
Dim RowX&
RowX = 3
Rows(RowX).Select

HTH
Cordially
Pascal

"Alan Tang" a écrit dans le message de
...
Hello:

I have try to use the following statment for select a row
and work fine.

Rows("2:2").Select

After I have change the value as show below, it can't work!

Rows("RowX:RowX").Select

For the Value os RowX is 3 as integer.

Thanks!