I'm getting the 1004 Runtime error - Method 'Range' of
object '_Global' failed in the following code copied from
the 2007 VBA Programmer's Reference on the 'With Range...) line.
Can anyone see a possible reason why please?
Spreadsheet Data:
Please Login or Register to view this content.
HTML Code:
Last edited by jp001; 04-20-2009 at 03:02 AM.
You're missing a Next statement.
Yes I omitted the last few lines; just edited to put them
in anyway...
I can only go on what you post here.
Have you checked that there is actually a range named "Mangoes"?
Oops! Thanks Stephen, that was it - a spelling error in a named range :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks