Thread: Reference to worksheet range in R1C1
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
JohanF[_6_] JohanF[_6_] is offline
external usenet poster
  
Posts: 1
Default Reference to worksheet range in R1C1

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