What is wrong with this code please?
comes up with error 1004 - method 'Range' of object'_Global' failed
Sheets "Sales" and "Donated" have headings "Name Date Item Price" in Row 1, Columns A-D
Please Login or Register to view this content.
and "Donated" has "=Donated" in A2
Spent hours trying to solve it so any help would be much appreciated
Last edited by JBeaucaire; 01-13-2013 at 04:51 AM. Reason: Added code tags, as per forum rules. Don't forget!
You've got too many quotes in the A2:D3 range notation. Does that fix your issue?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for your prompt reply but that was just a typo when I entered it on to the forum. (Its on a different computer so couldn't just copy and paste). The extra " is not in the code
I guess I'd need to see the workbook with the macro in it. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks