NEED HELP, SMALL QUESTION

[DiskDoctor]

i think i may have the solution worked out, perhaps someone can answer a
smaller question, i just want to select a cell based on a variable value.
For example variable3 = "A4" so i want to select A4 and cut that ROW.

any help appreciated!



Dim Variable3 as string

Variable3 = "A4"

Range(variable3).Select

 

[Norman Jones]

Hi DiskDoctor,

Try replacing

Range(variable3).Select

with

Range(Variable3).EntireRow.Delete

 

[Don Guillett]

or
mr=4
rows(mr).delete