How to set conditional format with vba?

#10

Posted to microsoft.public.excel.programming

deko[_3_]

external usenet poster

Posts: 62

How to set conditional format with vba?

correction: on the second time through the loop, I get an error:

Error Number 1004: Select method of Range class failed

The first time is fine, but the second time fails. I tried getting rid of
the Select A1 at the end, but no luck.

oops....

xlapp.Workbooks(strXlsFile).Worksheets(sn(i)).Acti vate

now it works...

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
New Conditional Format Overriding Previous Conditional Format	Rene	Excel Discussion (Misc queries)	3	February 27th 08 06:08 PM
copy conditional format to regular format	GDC	Setting up and Configuration of Excel	3	May 4th 05 09:35 PM
Multiple conditional on conditional format formula	Frank Kabel	Excel Programming	1	July 27th 04 06:24 PM
Multiple conditional on conditional format formula	Bob Phillips[_7_]	Excel Programming	0	July 27th 04 05:30 PM
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work	No Name	Excel Programming	0	May 3rd 04 12:22 PM

All times are GMT +1. The time now is 07:24 AM.

Menu

About Us