Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy cell to reference contained in another cell
another procedure I'm struggling with -
Cell B1 contains a variable cell reference, for example "E:14" I want to copy contents of cell $E$4 to the cell reference pointed to in the above Can't make it work - help would be appreciated . . . (does anyone know where can I find a comprehensive syntax guide?) Probably my last question - for now at least . . Thanks in advance . . . RonW. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy cell to reference contained in another cell
Hi Worlman1,
Try: Range("E4").Copy Destination:=Range(Range("B1").Value) --- Regards, Norman "Worldman1" wrote in message ps.com... another procedure I'm struggling with - Cell B1 contains a variable cell reference, for example "E:14" I want to copy contents of cell $E$4 to the cell reference pointed to in the above Can't make it work - help would be appreciated . . . (does anyone know where can I find a comprehensive syntax guide?) Probably my last question - for now at least . . Thanks in advance . . . RonW. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy cell to reference contained in another cell
Hi Norman,
Thanks, but there apears to be a syntax error . . Cheers, RonW. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy cell to reference contained in another cell
Hi Worldman1,
Thanks, but there apears to be a syntax error . . I do not think so - it works for me. However, try the following fully qualified version: '============= Public Sub Tester() Dim WB As Workbook Dim SH As Worksheet Set WB = Workbooks("YourBook.xls") '<<==== CHANGE Set SH = WB.Sheets("Sheet1") '<<==== CHANGE With SH .Range("E4").Copy Destination:=.Range(.Range("B1").Value) End With End Sub '<<============= --- Regards, Norman "Worldman1" wrote in message oups.com... Hi Norman, Thanks, but there apears to be a syntax error . . Cheers, RonW. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
Characters contained in a cell | Excel Discussion (Misc queries) | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions |