| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pretty easy If loop - help!!
How can I use an if loop to return the first number of a date.
For example, if cell A1 has the date: 7/06/2006, I want to say: If (ActiveCell.Characters(Start:=1, Length:=1).Text = "7") Then TodayInt = 7 End If But this is trying to look for a string and its finding a date, so I get an error...Anyone have a better idea?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding in loop | Charts and Charting in Excel | |||
| Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
| Loop gone crazy | Excel Discussion (Misc queries) | |||
| Do Loop | Excel Discussion (Misc queries) | |||
| How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
Threaded Mode
