Macro

[cvgairport]

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("A1730") = Range("A215").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]

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("A1730").value _
= worksheets("sheet888").range("a215").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("A1730").value _
= worksheets("myMasterSheetNameHere").range("a215").value

 

[JCS]

Hi Amy,

To programatically switch tabs, try: Sheets("Sheet2").Select Substitute
Sheet2 with the name(s) of your sheet tabs. Please press Yes if this helped
you.

JCS

 

[cvgairport]

Thanks! it appears to work!

Hi Amy,

To programatically switch tabs, try: Sheets("Sheet2").Select Substitute
Sheet2 with the name(s) of your sheet tabs. Please press Yes if this helped
you.

JCS