reference new sheet in same workbook
 

I can't seem to figure out how to calculate information from "sheet5" and
place it on sheet6 starting with

A:1
A:2
A:3 and so on.

Any help with the VBA code I need?

reference new sheet in same workbook
 

I'm not sure what your question is, but perhaps the following
will be useful.

Worksheets("Sheet6").Range("A1").Value = _
Worksheets("Sheet5").Range("A1").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"R Doornbosch" wrote in message
...
I can't seem to figure out how to calculate information from
"sheet5" and
place it on sheet6 starting with

A:1
A:2
A:3 and so on.

Any help with the VBA code I need?

reference new sheet in same workbook
 

when I use



Worksheets("Sheet6").Range(A, 1).Value = "My Name"

I get the error "Subject out of range"

I've tried changing "Sheet6" to the sheets name also.

reference new sheet in same workbook
 

Do you have a sheet in your workbook named Sheet6? Also, change

Range(A,1)
to
Range("A1")
or
Cells(1,"A")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"R Doornbosch" wrote in message
...
when I use



Worksheets("Sheet6").Range(A, 1).Value = "My Name"

I get the error "Subject out of range"

I've tried changing "Sheet6" to the sheets name also.

reference new sheet in same workbook
 

That worked THANKS