So i'm pretty new to macro use and i can get it to work pretty good a
long as i am only in one workbook. i use

cells(5,2).value

so what do i do to get it to go to another worksheet

how do i refrance other worksheet's while using macros?

thanx for the help

--
Message posted from http://www.ExcelForum.com

Neuther

Example only.

Worksheets("Sheet2").Range("A1:J10").Copy _
Destination:=ActiveSheet.Range("K43")

Copies a range of cells from Sheet2 to the worksheet that is active when you
call the macro.

For your example use

Worksheets("Sheet2").cells(5, 2).value = ActiveSheet.cells(7, 3).value

Or similar.

Try recording a macro while copying from one sheet to another to see the
syntax used.

Then go to Tushar Mehta's site and browse through "Beyond Excel's Recorder"

http://www.tushar-mehta.com/

And David McRitchie's "Getting started with Macros"

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP

On Fri, 20 Feb 2004 19:36:46 -0600, Neuther
wrote:

So i'm pretty new to macro use and i can get it to work pretty good as
long as i am only in one workbook. i use

cells(5,2).value

so what do i do to get it to go to another worksheet

how do i refrance other worksheet's while using macros?

thanx for the help.


---
Message posted from http://www.ExcelForum.com/