Your code doesn't really copy the values--it just assigns them.

And you don't have to select/activate a worksheet to work on it.

worksheets("sheet999").range("A17:P30").value _
= worksheets("sheet888").range("a2:p15").value

If you want to copy, er, assign a specific range from a specific sheet, you
could activate the new sheet and then use something like:

ActiveSheet.range("A17:P30").value _
= worksheets("myMasterSheetNameHere").range("a2:p15" ).value



cvgairport wrote:

Hi everyone -

I have a spreadsheet with multiple tabs. I have a need at the start of the
month to copy several sections on different tabs to other places on those
same tabs. Right now the macro I developed copies a single section to
another place:

Range("A17:P30") = Range("A2:P15").Value

I would like to stack these types of commands within a single macro to do
the copying of the various sections but I don't know how to, within the
macro, switch tabs.

Any help would be appreciated.

Amy

--

Dave Peterson