I have a macro that deals with data starting from cell A10 onward but cells A1 to A9 are off limits. I’m looking for a way to jump to A10 in case the wrong cell was selected.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
This works if A1 is selected but it would be sloppy to repeat this 8 more times for cells A2 to A9.
If ActiveCell.Address = ("$A$1") <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1
lace w:st="on"><st1:PlaceName w:st="on">Then</st1:PlaceName> <st1:PlaceType w:st="on">Range</st1:PlaceType></st1
lace>("A10").Select
<o
> </o
>
The following don’t work:
If ActiveCell.Address = ("$A$1:$A$9") <st1
lace w:st="on"><st1:PlaceName w:st="on">Then</st1:PlaceName> <st1:PlaceType w:st="on">Range</st1:PlaceType></st1
lace>("A10").Select
Or
If InRange(ActiveCell, Range("A1:A9")) <st1
lace w:st="on"><st1:PlaceName w:st="on">Then</st1:PlaceName> <st1:PlaceType w:st="on">Range</st1:PlaceType></st1
lace>("A10").Select
<o
> </o
>
I tried variations of this but it is eluding me.
<o
> </o
>
Thank you for any help.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




This works if A1 is selected but it would be sloppy to repeat this 8 more times for cells A2 to A9.
If ActiveCell.Address = ("$A$1") <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com



<o


The following don’t work:
If ActiveCell.Address = ("$A$1:$A$9") <st1


Or
If InRange(ActiveCell, Range("A1:A9")) <st1


<o


I tried variations of this but it is eluding me.
<o


Thank you for any help.