Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell data and assigning to variables
Excel 97 macro. I need to read cells on a worksheet and use that as an
address to paste data to. It sounds easy and probably is. But everything I try is not working. A B C 1 SheetNo RowNo ColumNo 2 sheet2 1134 3 3 sheet3 2278 3 4 sheet4 3389 3 on sheet1 read A2 read B2 read C2 It should copy cells A1:D100 of sheet2 and paste the date to sheet1 column 3 row 1134 copy cells A1:D100 of sheet3 and paste the date to sheet2 column 3 row 2278 etc. I can copy cells, paste cells, change worksheets, and change workbooks. Mostly thanks to help from these forums. I can't read three cells and assign data to three variables (SheetNo, RowNo, ColumNo) and make it work. Sigh. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning cell values to variables | Excel Discussion (Misc queries) | |||
Assigning Cell data to VB Variables | Excel Programming | |||
MS Office Excel 2003 assigning cell values to variables | Excel Programming | |||
Assigning multiple text strings to variables | Excel Programming | |||
Assigning cell address components to variables | Excel Programming |