Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through A Range
What I am trying to do is have a user select a range of cells and then what I
would like to do is cycle through just these cells. This is basically like if I where on a worksheet and selected a range of cells and hit the enter key. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through A Range
What's the end use of the code? -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47032 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through A Range
Looks through the selected cells (not the entire work sheet) for a specific
phrase If it finds the phrase in the cell then 1) Capitalize just the phrase 2) Marks the cells that have the phrase with a red back color 3) Copy's the cells that have the phrase to another work sheet 4) Move to next cell Currently the user selects the range and then does a find for the phrase and then manually does everything above. I know how to do all the steps if the user where just selecting one cell, but ran into a problem on the multiple cells as I can't figure out how to find out which cells the user selected and then move through them. It should also be noted that the user could select cells with the Ctrl button so "range" might not be all together. "royUK" wrote: What's the end use of the code? -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47032 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through A Range
Dim myRng as range
dim myCell as range set myrng = selection for each mycell in myrng.cells if lcase(mycell.value) = lcase("yourexactphrasehere") then 'do the work end if next mycell This looks for cells that match the phrase you want--not just contains the phrase. if lcase(mycell.value) like "*" & lcase("yourphrasehere") & "*" then might be what you want. jutlaux wrote: Looks through the selected cells (not the entire work sheet) for a specific phrase If it finds the phrase in the cell then 1) Capitalize just the phrase 2) Marks the cells that have the phrase with a red back color 3) Copy's the cells that have the phrase to another work sheet 4) Move to next cell Currently the user selects the range and then does a find for the phrase and then manually does everything above. I know how to do all the steps if the user where just selecting one cell, but ran into a problem on the multiple cells as I can't figure out how to find out which cells the user selected and then move through them. It should also be noted that the user could select cells with the Ctrl button so "range" might not be all together. "royUK" wrote: What's the end use of the code? -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47032 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through A Range
Works great.
Thanks! "Dave Peterson" wrote: Dim myRng as range dim myCell as range set myrng = selection for each mycell in myrng.cells if lcase(mycell.value) = lcase("yourexactphrasehere") then 'do the work end if next mycell This looks for cells that match the phrase you want--not just contains the phrase. if lcase(mycell.value) like "*" & lcase("yourphrasehere") & "*" then might be what you want. jutlaux wrote: Looks through the selected cells (not the entire work sheet) for a specific phrase If it finds the phrase in the cell then 1) Capitalize just the phrase 2) Marks the cells that have the phrase with a red back color 3) Copy's the cells that have the phrase to another work sheet 4) Move to next cell Currently the user selects the range and then does a find for the phrase and then manually does everything above. I know how to do all the steps if the user where just selecting one cell, but ran into a problem on the multiple cells as I can't figure out how to find out which cells the user selected and then move through them. It should also be noted that the user could select cells with the Ctrl button so "range" might not be all together. "royUK" wrote: What's the end use of the code? -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47032 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
cycle time out of range error | Excel Discussion (Misc queries) | |||
cycle thru controls | Excel Programming | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
Cycle through all the available Fonts | Excel Programming |