Fri 25 Apr 2008, 16:42Delegate Gareth said...
Gareth has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Named Ranges In Excel
There is an option to ignore blank cells but I have found that if I select a range including blacks sometimes it ignores them and sometimes it doesn't. Why is this the case?
Mon 12 May 2008, 00:53Trainer Tracy said...
RE: Named Ranges In Excel
Hi Gareth,
It could be that you may have put a space in the cell and the computer recognises it as a character though you cannot see it?
Tracy
