Help with Array formula not setting required cells to specified value for all selected sheets.

[Kayslover]

Hi All,

I have a macro that uses the following command and it works as expected:-

Sheets(Array("Jan Income", "Feb Income", "Mar Income", "Apr Income", "May Income", "June Income", "July Income", "Aug Income", "Sept Income", "Oct Income", "Nov Income", "Dec Income")).Select

Range("B6:B7,F7,I6:BZ7").Select

Selection.ClearContents

I also require certain cells to be set to 0 and have therefore added the following after Selection.ClearContents in the above:-

Range("F6,G6,E7,F7").Value = 0

However, the last command only sets the above cells in sheet called Jan Income to 0. The other sheets do not get populated.

Any assistance you can offer would be appreciated.

 

[igold]

Try replacing this line

Range ("F6,G6,E7,F7").Value = 0

With this

Range("F6,G6,E7,F7").Select
Selection.Value = 0

 

[Kayslover]

igold,

Firstly, sorry for the delay in responding to your post. I have been out of town for a few days.

Secondly, Your recommendation worked a treat.

Lastly, I appreciate your kind assistance.

 

[igold]

No problem, I am glad it worked for you. Thanks for the feedback!