Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Wrote some test code to try to solve a problem in another post.
Sub RangeNumber() Set ws = ActiveSheet Set rstartcell = ws.Range("A2") Set rNumber = ws.Range(rstartcell, rstartcell.End(xlDown)) Row = rstartcell.Row rnum = Left(Cells(Row, 1), 2) Select Case rnum Case rnum = 11 But the code skips over Case rnum=11 and goes on to the next case, even though rnum is 11. I also tried putting the 11 in quotes to tell XL that it's text, but it didn't help. Any ideas why? Thanks as always. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif number is greater than a number but less than another number | Excel Discussion (Misc queries) | |||
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |