Email to attach sheet s values only for a specific range

[Howardc1001]

I have tried to write code to copy range A1:O50 and to paste these as values and to attach the sheet only for this range as values (no formulas)


However the entire sheet is being copied including columns with formulas after Col O


It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

[Sintek]

What are you wanting to do with these red snippets...

Please Login or Register  to view this content.

copy range A1:O50 and to paste these as values

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help Sintek

The first Red Snippet was to only paste the values for the range A1 to O50

The second red snippet was to delete the new sheet added fter attaching the sheet

[Sintek]

See code in post 2 that paste values only...


the delete snippet should actually be a kill command after attaching the newly created workbook...

Edit...Nope ignore above remark...I see now that you want to delete the newly created sheet...
So Are you wanting to attach the active workbook

Or just the copied range to a new book and attach the new book...

[Sintek]

Something tells me...This is what you are trying to do...
Copy range of specific sheet in active workbook to a new workbook, renaming new workbook active sheet and then saving this new workbook, attaching it in email and the deleting this new workbook...If so, see below...

For testing, I have left a few things out...Sure you can add again...

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the explanation and help

[davsth]

maybe after the second snippet from sintek

Please Login or Register  to view this content.

[Howardc1001]

Your code in Post # 5 was of great help

I added what I need and it works perfectly

[Howardc1001]

thanks davesth

[Sintek]

Your code in Post # 5 was of great help

I added what I need and it works perfectly

Glad you got it sorted...Happy Coding...