Thread: Reference to worksheet range in R1C1
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Reference to worksheet range in R1C1
Dim rng as Range
With Worksheets("Macros")
set rng = .Range(.Cells(29, 1), .Cells(lastrow, 2))
End with

msgbox rng.Address(0,0,xlA1,True)

--
Regards,
Tom Ogilvy

"JohanF" wrote in
message ...

If I use

Worksheets("Macros").Range(.Cells(29, 1), .Cells(lastrow, 2))

I get a sytax type of error??


--
JohanF
------------------------------------------------------------------------
JohanF's Profile:
http://www.excelforum.com/member.php...o&userid=33779
View this thread: http://www.excelforum.com/showthread...hreadid=535513



Reply With QuoteReply With Quote