| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| R1C1 reference | Excel Discussion (Misc queries) | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| R1C1 reference | Excel Discussion (Misc queries) | |||
| Getting the value from a cell, and then using it as a name or R1C1 reference | Excel Programming | |||
Threaded Mode
