Hello,
I am trying to set some values for a range but am a bit stuck.
When using this code it works fine:
But when using this code i get a Run Time Error 1004
Please Login or Register to view this content.
Can any body help me here and point out why this produces an error, i want to use the second option to set values for a variable range and prefer to use the Cells() method?Please Login or Register to view this content.
Thanks!
Could you provide your workbooks? Would be easier that way.
I think this might be caused because you need to clarify what workbook and cells you are refeering to, and the later part of your code is trying to reference the book2 cells.
You could try to add this bit of code at the start of the module:
And replace that line of code with:Please Login or Register to view this content.
As you can see the difference is that my line is refering to a specific workbooks worksheets cells.Please Login or Register to view this content.
Tuomas "Banaanas" Savonius
Trying to give back now when I actually can do some VBA
Try
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you very much i think you helped me figure it out.
The issue was the way i selected my range, i was using
Whereas, the way your wrote it using works just finePlease Login or Register to view this content.
I tried it and all working! thanks again.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks