E
Ed Landau
I'm stumped.... can someone help?
The following line of code works fine. It shifts the column down and inserts
a blank cell at F1
Range("F1").Insert xlShiftDown
The following line of code returns an error: "Insert Method class failed"
Range("F1").Insert xlShiftDown, Range("B1")
I've tried adding a ".value" to the CopyOrigin (the second argument). I've
tried adding parentheses. I've tried declaring a variant and using it as
the CopyOrigin argument. I can't get it to work.
All I want is to insert cell B1 into F1 and shift the F column down.
The next step will be to insert a whole row from a row in a different sheet
Any help appreciated.
Thanks
_Ed
The following line of code works fine. It shifts the column down and inserts
a blank cell at F1
Range("F1").Insert xlShiftDown
The following line of code returns an error: "Insert Method class failed"
Range("F1").Insert xlShiftDown, Range("B1")
I've tried adding a ".value" to the CopyOrigin (the second argument). I've
tried adding parentheses. I've tried declaring a variant and using it as
the CopyOrigin argument. I can't get it to work.
All I want is to insert cell B1 into F1 and shift the F column down.
The next step will be to insert a whole row from a row in a different sheet
Any help appreciated.
Thanks
_Ed