Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy from active sheet only
I think I got it. By deleting the sheet name and only using the range address seems to work. I tried it on a couple of months, if it blows up next month I'll be back. Thanks.- wanttoobe
- Post #4
- Forum: Office suites general discussion
-
copy from active sheet only
Thanks much I was unable to get it to work. But I probably inserted it wrong. [Window 2].Activate [Feb04:A5].Select Selection.Reshape [Feb04:A5..Feb04:O32] Selection.CopyToClipboard I want Feb04 (the sheet name) to be whatever the active sheet name is ie: Mar04, Apr04, May04...- wanttoobe
- Post #3
- Forum: Office suites general discussion
-
copy from active sheet only
I have a sheet for each month. At the end of the month I want to copy a range to another sheet for printing. I'd like to do this via script so that what ever sheet is active will have that range copied. Is there anything like Excel's ActiveSheet? I looked in FAQ and did a Keyword Search...- wanttoobe
- Thread
- Replies: 3
- Forum: Office suites general discussion
