Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
whats wrong with this code
Hi
Cany anyone tell me what's wrong with the code below. I get an application defined or object defined error With ActiveWorkbook.Sheets(1) .Range(d9) = ThisWorkbook.Sheets(1).Range(b3) .Range("h6") = ThisWorkbook.Sheets(1).Range("b16") .Range("h7") = ThisWorkbook.Sheets(1).Range("d16") .Range("h8") = ThisWorkbook.Sheets(1).Range("g16") End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
whats wrong with this code
Hi Lisa
at a glance .Range(d9) = ThisWorkbook.Sheets(1).Range(b3) should be .Range("d9") = ThisWorkbook.Sheets(1).Range("b3") Cheers JulieD "LiSa" wrote in message ... Hi Cany anyone tell me what's wrong with the code below. I get an application defined or object defined error With ActiveWorkbook.Sheets(1) .Range(d9) = ThisWorkbook.Sheets(1).Range(b3) .Range("h6") = ThisWorkbook.Sheets(1).Range("b16") .Range("h7") = ThisWorkbook.Sheets(1).Range("d16") .Range("h8") = ThisWorkbook.Sheets(1).Range("g16") End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doh
I'd missed out the "" - how embarrassing.
Thanks for the help with the previous query guys -----Original Message----- Hi Cany anyone tell me what's wrong with the code below. I get an application defined or object defined error With ActiveWorkbook.Sheets(1) .Range(d9) = ThisWorkbook.Sheets(1).Range(b3) .Range("h6") = ThisWorkbook.Sheets(1).Range("b16") .Range("h7") = ThisWorkbook.Sheets(1).Range("d16") .Range("h8") = ThisWorkbook.Sheets(1).Range("g16") End With . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
whats wrong with this? | Excel Discussion (Misc queries) | |||
Whats wrong with this? | Excel Discussion (Misc queries) | |||
Whats Wrong with this?? | Excel Worksheet Functions | |||
Whats wrong? | Excel Programming | |||
Whats wrong with this code | Excel Programming |