Accessing a cell in a different worksheet with a macro

[etpeterson]

I h ave a workbook with 16 worksheets. In worksheets 2-16 I need to get a value in worksheet 1 and then paste it into each worksheet. This needs to be done within a large subroutine so I don't want to do this iterativley. Currently, my macro selects WS1, gets the value and then selects WS2 and pastes the value. I would like my subroutine to get the value without having to actually select the worksheet. That way as I create the individual worksheets, I can say, "get data from cell B10 in WS1 and past it in the current worksheet." Then when the next worksheet is created, I can execute the same code.

Please Help!

Thanks,
Eric

 

[R_Stephens]

Hi there

Try something like this

ActiveSheet.Range("a1").Value = Worksheets("Sheet1").Range("b2").Value

This will copy the value from B2 on Sheet1, to cell A1 on the active sheet.

Hope it helps

Richard