Where to delete

[Todd Huttenstine]

Wks.Rows(i).Resize(, 1).Delete Shift:=xlShiftUp

The (, 1) part of this code specifies to delete the actual
cell. I want to delete that cell and also the cell just
to the left of it. Everytime I put in -1 I get an error.

How do I fix this?

Todd

 

[Roger Whitehead]

Looks like you're trying to resize a row, by it's columns - not possible.

Can you explain what you're trying to achieve?

 

[Bob Phillips]

Wks.Rows(i).Offset(0,-1)Resize(, 2).Delete Shift:=xlShiftUp

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Roger Whitehead]

Ah...... Nice.