Problem in defining range

Untested:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hi Excelnoub,

Thanks for your reply.

I tried both your suggestions but it is not showing the error. Nothing is happening.

I couldn't figure out the problem

Just to check... What is your Tab's name?

Data Sheet

Untested

Please Login or Register  to view this content.

Enabled VBA references.JPG

These are the enables VBA references. Is there anything I have left.

I have tried your above statement also. But nothing is happening.

I am using these codes in 2003 version of excel. Is that the problem?

Hard to see without a demo sheet... if you could upload one or try to see if you cannot implement the Ron De Bruin Outlook mail code... Working in Office 2000-2010

http://www.rondebruin.nl/

Hi Excelnoub,

Sorry for late reply.

Please find atttached the sample file I am using.

Please help.

Thanks,
aganesan99

You are working with 2010 right?

I have changed my reference to 12.0 Object library and I get the following message when runing the macro:

"Please enter the begining row" Then VB msg: "D:\\template\\ Not found"

Works on 2007

Hi Excelnoub / xlbiznes,

Thanks for your help. I figured out what the problem is and solved it. Its because from column A to column AR, the range was defined as a Table and so it didn't pick it think. I converted into normal range and then it worked.

Thanks for your effort and time.

aganesan99