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

---
Regards,
Norman



"DiskDoctor" <diskdoctor@rogers.com> wrote in message
news:VLSdneBiZYfi6xHfRVn-hQ@rogers.com...
>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
>
>

[Don Guillett]

or
mr=4
rows(mr).delete

--
Don Guillett
SalesAid Software
donaldb@281.com
"DiskDoctor" <diskdoctor@rogers.com> wrote in message
news:VLSdneBiZYfi6xHfRVn-hQ@rogers.com...
> 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
>
>