| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reference new sheet in same workbook
That worked THANKS
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference to sheet name in another workbook | Excel Discussion (Misc queries) | |||
| Setting a cell reference in one sheet that updates a workbook? | Excel Discussion (Misc queries) | |||
| How do I use an indirect reference to a sheet in another workbook? | Excel Discussion (Misc queries) | |||
| reference different sheet in same workbook | Excel Worksheet Functions | |||
| Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
