whats wrong with this code

  • Thread starter Thread starter LiSa
  • Start date Start date
L

LiSa

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
 
Hi Lisa

at a glance

.Range(d9) = ThisWorkbook.Sheets(1).Range(b3)
should be
.Range("d9") = ThisWorkbook.Sheets(1).Range("b3")

Cheers
JulieD
 
I'd missed out the "" - how embarrassing.

Thanks for the help with the previous query guys
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining 2 Text Strings in Body of E-Mail Q 2
Simple IF give me nothing? 2
Sort in hidden page crach 8
HELP!!! I can't set formula to cell 1
Merge data from two temp files into a master 1
Snag in invoice generator. How to change the "series" 5
What am I doing wrong? Sending values from one worksheet to another in new workbook 4
1004: Activate method of Range class failed 1

Back
Top