selecting a range
 

Hi everyone! I'm very new to all this and hope someone can help. I hav
very little experience. I looked on your forum and I believe I want t
do something similar to MichaelC but I could not fully get it. What
need to do is run a macro that will select all the cells from th
current cell I'm in to cell AW262. For example, If I was on cell D
when I run my macro all cells from ("D6:AW262") would be selected. If
was on cell D150 when I run the macro it would select all cells fro
("D150":AW262") ect. From whatever cell I am in I want it to select
range from and including that cell to AW262.

Thank You for any help you can give

Suz

--
Susan
-----------------------------------------------------------------------
SusanL's Profile: http://www.excelforum.com/member.php...fo&userid=2425
View this thread: http://www.excelforum.com/showthread.php?threadid=37867

selecting a range
 

Something like this?

Public Sub SelectMyCells()
ActiveSheet.Range(Selection, "AW262").Select
End Sub
--
HTH...

Jim Thomlinson


"SusanL" wrote:


Hi everyone! I'm very new to all this and hope someone can help. I have
very little experience. I looked on your forum and I believe I want to
do something similar to MichaelC but I could not fully get it. What I
need to do is run a macro that will select all the cells from the
current cell I'm in to cell AW262. For example, If I was on cell D6
when I run my macro all cells from ("D6:AW262") would be selected. If I
was on cell D150 when I run the macro it would select all cells from
("D150":AW262") ect. From whatever cell I am in I want it to select a
range from and including that cell to AW262.

Thank You for any help you can give

Suzy


--
SusanL
------------------------------------------------------------------------
SusanL's Profile: http://www.excelforum.com/member.php...o&userid=24258
View this thread: http://www.excelforum.com/showthread...hreadid=378672

selecting a range
 

Suzy - Jim's reply to yours and mine finally helped me o get there. Mt
resolution is attached to the original thread.

"Jim Thomlinson" wrote:

Something like this?

Public Sub SelectMyCells()
ActiveSheet.Range(Selection, "AW262").Select
End Sub
--
HTH...

Jim Thomlinson


"SusanL" wrote:


Hi everyone! I'm very new to all this and hope someone can help. I have
very little experience. I looked on your forum and I believe I want to
do something similar to MichaelC but I could not fully get it. What I
need to do is run a macro that will select all the cells from the
current cell I'm in to cell AW262. For example, If I was on cell D6
when I run my macro all cells from ("D6:AW262") would be selected. If I
was on cell D150 when I run the macro it would select all cells from
("D150":AW262") ect. From whatever cell I am in I want it to select a
range from and including that cell to AW262.

Thank You for any help you can give

Suzy


--
SusanL
------------------------------------------------------------------------
SusanL's Profile: http://www.excelforum.com/member.php...o&userid=24258
View this thread: http://www.excelforum.com/showthread...hreadid=378672

selecting a range
 

That's It

Thank You very Much!


--
SusanL
------------------------------------------------------------------------
SusanL's Profile: http://www.excelforum.com/member.php...o&userid=24258
View this thread: http://www.excelforum.com/showthread...hreadid=378672