Delete range and shift up

[sharky12345]

I'm trying to find a way to delete a range, (not the whole row), and shifting cells up but using the Listindex property of a Listbox as the row reference.

I have stored the row number as 'Row' but need to know how I can use it in the following:

[COLOR=#242729][FONT=Consolas]Range("A12:L12").Delete Shift:=xlUp[/FONT][/COLOR]

A simple solution I'm sure, but everything I've tried doesn't work....

 

[Akuini]

Try:

Range("A" & Row & ":L" & Row).Delete Shift:=xlUp

 

[sharky12345]

Thanks!!

 

[Rick Rothstein]

Here is another code line you can try...

Intersect([A:L], Rows(Row)).Delete xlUp

 

[sharky12345]

Thanks Rick....