Row Select
Sorry, I misunderstood. If you always want the data from column AD then try:
Range("A2") = Range("AD:" & ActiveCell.Row)
--
Vasant
"Syr Doug" wrote in message
...
Thanks for the reply, not quite. I know about Active Cell. I need more
the current row
This will be pretty much static.
Cell A1 = I will need the data value of the AD + currentrow
Cell B1 = I will need the data value of the AE + currentrow
Cell A2 = I will need the data value o fhte AF + currentrow
|