Email Sheet based on Sheet namesin Col A on sheet "Macro"

[Howardc1001]

I have tried to write code to email those sheets that are in Col A o sheet "Macro"

It would be appreciated if someone can help me resolve this

Please Login or Register  to view this content.

[Sintek]

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek

Thanks for the help. I have made the necessary changes. When running the macro , I now het run time error 1004 and the code below is highlighted


[codde].SaveAs Filename:=File, FileFormat:=51 [/code]


Kind Test & advise

[bakerman2]

Please Login or Register  to view this content.

[Sintek]

I don't get it...This file has nothing to do with your initial request...
And no such code exists...

Please Login or Register  to view this content.

If you are referring to your first upload then the code errors as there is no reference to your variable "File"....

So incorporate something like this...

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek


Thanks for the help, code works perfectly

I have formulas in A onwards to only show sheets where there are variances and those with no variance as shown as a blank

I there a way to increase the range of the array so that when there is a variance on another sheet , that sheet will also be included on the attachment ?

If so, please amend code

I tried to increase the range, where cell A5 is displaying blank , but get a run time error

Please Login or Register  to view this content.

[Howardc1001]

Thanks for your help, Bakerman2

[Sintek]

Howard...I'm confused...What file are you referring to...

Seems you have two individual requirements | 2 individual files running same thread

I tried to increase the range, where cell A5 is displaying blank , but get a run time error

Cannot refer to a sheet if there is no name allocated to it...

[Howardc1001]

Sinek, sorry for any confusion caused

I amended my sample file slightly , as I would like the array range to increase as the range increases in Col A with the sheetnames-see attached sample data

[Sintek]

Amend code to Incorporate...

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek

This is brilliant. Works like a charm

Thanks very much for your help once again

[Sintek]

..........................
Image 1.gif