Hi !

Using Access XP, I'm generating an Excel worksheet.

I have two questions :

1) If I use the following line to select two non contiguous ranges

With xlsSheet.Range("H3:P36,R3:Y36")
...

I get the error message 1004 : method 'Range' of '_Worksheet' failed.

This is strange because the macro recorder uses the same syntax :
Range("H3:P36,R3:Y36").Select

(I tried the .Select method in Access VBA as well, with the same
result).

What wrong ?


2) Is it possible to apply a conditional formatting to all cells of a
range without :
- having to loop thru each cell ?
- use .FormatConditions, because I have more than 4 conditions
(actually 6)

The formatting I want to set is the bacgroung color only.

Since the file I generate is static (ie: won't be edited later), I
don't need the formatting logic to be dynamic.


Thanks !

FU2: microsoft.public.access