Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
selecting a range | Excel Programming | |||
Help please in selecting range dependent on another range | Excel Programming | |||
Selecting a Range inside a range | Excel Programming |