Offset Code
Todd,
Tested it and it worked fine for me.
Dave posted the same method that I did.
He also gave you another choice which should also work.
If neither of them work for you, then there's something that
you're not telling us.
John
"Todd Huttenstine" wrote in message
...
That did not work.
-----Original Message-----
Todd,
Try:
Cells(i1, "N").Resize(,4).Delete Shift:=xlShiftUp
John
"Todd Huttenstine"
wrote in message
...
I have the following code that deletes a certain cell...
Cells(i1, "N").Delete Shift:=xlShiftUp
I would like it to also delete the next 4 cells to the
right using the same delete method? I would assume I
would have to use an offset method. Can anyone please
tell me how to do this?
Thank you
Todd Huttenstine
.
|