Thread: Offset Code
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default Offset Code

I got it to work. thanx. For some reason I forgot to add
my shift code.

Thanx to both.


-----Original Message-----
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


.



.