Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using this vba to copy/delete a row of data from "Allocations" to
"Outcomes": Private Sub MoveToOutcomes_Click() If Selection.Rows.Count 1 Then Exit Sub Set sht = Sheets("Outcomes") lastrow = sht.Cells(Cells.Rows.Count, "A").End(xlUp).Row ActiveCell.EntireRow.Copy _ Destination:=sht.Range("A" & lastrow + 1) ActiveCell.EntireRow.Delete End Sub This code had been working perfectly until today but I'm now getting a "Compile error - Can't find project or library" message. I haven't made any changes to the workbook so I'm not sure what I've done wrong? Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver - error - Compile Error | Excel Discussion (Misc queries) | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |