Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi again Ralph,
I decided to do a search for where you have zeros instead of alpha O and found quite a few. In your VBA editor, select the section of code and use the Edit - Find and enter a zero and you will find them all. Note that I think that Barbara's answer is the better solution. However, personally I would modify the following so that I did not have to work out the column number of CQ. It then becomes self documenting for the column Id and easy to modify if required. lastCol = Columns("CQ").Column 'Then use in following For myCol = 1 To lastCol -- Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
Run-time error '1004'; Method 'Export' of object'_Chart' failed | Excel Programming | |||
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method | Excel Programming | |||
excel chart export error runtime 1004 | Charts and Charting in Excel | |||
excel chart export error runtime 1004 | Excel Programming |