Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make Sheets.(Range 1) = Sheets.(Range 2)
I am getting an Error on the line indicated below. FacePlastic_BOM is
declared and calculated in another Sub in the UserForm. For now FacePlastic_BOM = 160. Dim LastRow As Single Sheets("BOM & Labor").Unprotect "AdTech" LastRow = Sheets("BOM & Labor").Cells(Rows.Count, "A").End(xlUp).Row + 1 'plastic material 'ERROR == Sheets("BOM & Labor").Range(Cells(LastRow, "A"), Cells(LastRow, "D")) = _ Sheets("Parts List").Range(Cells(FacePlastic_BOM, "A"), Cells(FacePlastic_BOM, "D")) Thanks in Advance, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
same range name in different sheets | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
range of data from different sheets | Charts and Charting in Excel | |||
sheets.range and adding cells that are out of the range | Excel Programming |