copy from active sheet only 1

[wanttoobe]

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, either I don't know how to ask or it isn't there.

Thanks

 

[crazybird]

I'm sure there is a script equivalent.

In a macro you can access the formula:

@CELLPOINTER("sheet&quot

or

@CELLPOINTER("sheetname&quot

One possible implementation:

{EDIT-QUICK-COPY dest;+@CELLPOINTER("sheetname&quot&":A1.."&@CELLPOINTER("sheetname&quot&":B6"}

 

[wanttoobe]

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 etc.

Thanks Again

 

[wanttoobe]

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.