Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste values macro
I am bouncing around code for this and overcomplicating it. What code can I
use to paste all values on every sheet for every cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste values macro
for each sh in Worksheets
sh.UsedRange.Cells.Value = sh.UsedRange.Cells.Value Next Merged cells may be problematic (aren't they always) - I haven't tested it with those. -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... I am bouncing around code for this and overcomplicating it. What code can I use to paste all values on every sheet for every cell. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste values macro
Thanks, but I ended up using this. Thanks for pointing me in the right
direction. i was having trouble with the paste values function. For Each sh In Worksheets Range("a19:d23").Select Selection.Copy Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next End Sub "Tom Ogilvy" wrote: for each sh in Worksheets sh.UsedRange.Cells.Value = sh.UsedRange.Cells.Value Next Merged cells may be problematic (aren't they always) - I haven't tested it with those. -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... I am bouncing around code for this and overcomplicating it. What code can I use to paste all values on every sheet for every cell. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste values macro
I think you will be disappointed in the results. Instead, modify it like
this For Each sh In Worksheets sh.Activate Range("a19:d23").Select Selection.Copy Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... Thanks, but I ended up using this. Thanks for pointing me in the right direction. i was having trouble with the paste values function. For Each sh In Worksheets Range("a19:d23").Select Selection.Copy Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next End Sub "Tom Ogilvy" wrote: for each sh in Worksheets sh.UsedRange.Cells.Value = sh.UsedRange.Cells.Value Next Merged cells may be problematic (aren't they always) - I haven't tested it with those. -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... I am bouncing around code for this and overcomplicating it. What code can I use to paste all values on every sheet for every cell. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste values macro
This was the final code in case anyone was interested. Again, thanks for
your help and direction, Tom. For Each sh In Worksheets sh.Activate sh.Range("a19:d23").Select Selection.Copy sh.Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next "Tom Ogilvy" wrote: I think you will be disappointed in the results. Instead, modify it like this For Each sh In Worksheets sh.Activate Range("a19:d23").Select Selection.Copy Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... Thanks, but I ended up using this. Thanks for pointing me in the right direction. i was having trouble with the paste values function. For Each sh In Worksheets Range("a19:d23").Select Selection.Copy Range("a19:d23").Select Selection.PasteSpecial Paste:=xlPasteValues Next End Sub "Tom Ogilvy" wrote: for each sh in Worksheets sh.UsedRange.Cells.Value = sh.UsedRange.Cells.Value Next Merged cells may be problematic (aren't they always) - I haven't tested it with those. -- Regards, Tom Ogilvy "dogpigfish" wrote in message ... I am bouncing around code for this and overcomplicating it. What code can I use to paste all values on every sheet for every cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Cut and paste Values | Excel Discussion (Misc queries) | |||
A macro to paste values | Excel Discussion (Misc queries) | |||
Paste Values Macro | New Users to Excel | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |