View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
 
Posts: 196
Default Paste Special atop original sheet in Macro


Why and for what reason? Most people would want to paste
values only or something or other. To just copy and paste
for no reason is stupid



-----Original Message-----
There must be an easy way to copy the entire active sheet

and paste it
atop itself. So far all I've been able to do is paste it

to another
sheet with a specified range (don't wish to use

a1:iv65536) or copy all
sheets with any range to a new sheet. I suppose I could

modify them to
fit my needs, but I'd really appreciate some help here.

Especially
since it should be easier that the first two I

mentioned. Thank you in
advance. -MACRE


---
Message posted from http://www.ExcelForum.com/

.