Mail Macro

[Ron de Bruin]

You not have to change anything in the code
Send me the workbook private and i look at it for you tomorrow

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


I have sheet with name ("LoookupTable") in work book with code & there
is also data available in sheet.
When i used the earlier macro then it works find but when i used new
code the macro show error " Unable to get the Specialcell property of
the range class"

have u used Vlookup function in new macro?

 

[Ams]

Hi Ron

I have sent files on ur mail address. Kindly chek the same

 

[Ron de Bruin]

Hi Ams

Two problems

In your code there is a - in this part

SpecialCells(xlCellType-Constants)

Must be

SpecialCells(xlCellTypeConstants)

strange it was not in the code I posted



And because you use sheet names with numbers change

SourceWB.Sheets(cell.Value).Copy

To

SourceWB.Sheets(cell.Text).Copy


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Hi Ron

I have sent files on ur mail address. Kindly chek the same

 

[Ams]

Working perfectly Fine

Thanxs a Ton

Hi Ams

Two problems

In your code there is a - in this part

SpecialCells(xlCellType-Constants)

Must be

SpecialCells(xlCellTypeConstants)

 strange it was not in the code I posted

And because you use sheet names with numbers change

SourceWB.Sheets(cell.Value).Copy

To

SourceWB.Sheets(cell.Text).Copy

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm


Hi Ron

I have sent files on ur mail address. Kindly chek the same







...

read more »- Hide quoted text -

- Show quoted text -