I was to delete a row from cell reference.
I have created a macro that returns the address of a cell eg. $A$15 in a variable.
With this address I was to created a code that deletes row 15.
more examples $B$5 delete row 5
$c$20 delete row 20
I was thinking of using left(variable,2) but this doesnt work..
Thank you in advance.