Thread: ActiveCell.Row in Range().Select?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thebluerider thebluerider is offline
external usenet poster
  
Posts: 1
Default ActiveCell.Row in Range().Select?

I got a scipt containing this code:

Code
-------------------
Range("H22:K22").Selec
-------------------


Now I'd like make the row numer "22" dependant on the active cell.

So something like this (just explanatory, since the following code i
not working ofc):

Code
-------------------
Range("HActiveCell.Row:KActiveCell.Row").Selec
-------------------


Can anyone show me how to accomplish that

--
theblueride
-----------------------------------------------------------------------
thebluerider's Profile: http://www.excelforum.com/member.php...fo&userid=3775
View this thread: http://www.excelforum.com/showthread.php?threadid=57336

Reply With QuoteReply With Quote