Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm Confused........................................
I am trying to copy the value of the last cell with a value on sheet 1 column
B to the first blank cell on sheet 2 column B, but I keep getting errors in my script (please see below) am I missing something really obvious? (Error Message "run-time error 1004") Worksheets(2).Cells(1, 1).Value = "CB Barcode" Worksheets(2).Cells(1, 2).Value = "8 Digit Code" Worksheets(2).Cells(2, 2).Value = " " Range("B2").Select Selection.ClearContents Worksheets(1).Select Range("B1").Select ActiveCell.SpecialCells(xlLastCell).Select Selection.Copy Worksheets(2).Select Range("B2").Select ActiveSheet.Paste Tia Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
confused | Excel Worksheet Functions | |||
confused. Please help. | Excel Discussion (Misc queries) | |||
Very confused.... | Excel Discussion (Misc queries) | |||
Confused | New Users to Excel | |||
:S confused :S | Excel Discussion (Misc queries) |