correction on the last command.
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks("Anodize.xls").Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
Workbooks("Quote.xls").Sheets(1).Cells(1).Curre
assuming that the both workbooks are openned
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks("Anodize.xls").Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
Workbooks("Quote.xls").Sheets(1).C
Can someone help with the following: In one workbook named (Quote) I
would like to copy the contents of Columns A and B to another workbook
named (Anodize). Where the copied contents from (Quote) would be
placed on the next available blank row in Sheet1 Columns A and B. I
know how to place a Comman
