Paste special cells

[Supriya]

Deal all,

I have one excel file with different division. i just want to paste the data in outlook division wise. kindly suggest for passing only visible cell range to 'rngtohtml' function which is used for coping data from excel to outlook.

Regards,
Supriya.

 

[srinidhi]

Highlight the data you want to copy
Press f5>Special>Visible Cells Only>ok
Now copy the data it will copy on the visible cell & not the hidden cells.

Hope this solves your problem.

 

[krishnaraj]

Try taking the data into a pivot table and report using divisions.

 

[Supriya]

thank for reply.
but problem still not resolved. after pasting the cell range in outlook the table's auto row height & coulumn width is not possible to set through code

pl assist.

Regards,
Supriya.

 

[lohithsriram]

Supriya,

A file upload is always a better option to get more and accurate response. Upload a sample file, if you cant get the complete file here.

 

[Supriya]

See the attached file with macro code

 

[SirJB7]

Hi, Supriya!
Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you.
Regards!