Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know it's heresy to branch. So how do I handle this situation? I have
some code taking a date from a cell and doing a MONTH command to extract the month and process based on that month number. Sometimes, the cell that normally contains the date contains text like "na" or "?". Then I get a type mismatch error on this line: dteColCode = rngColCode.Value How can I instruct it to skip down to the line "Next rCell" if an error occurs on this line? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I Skip a row in my formula? | Excel Worksheet Functions | |||
using IF to skip | Excel Worksheet Functions | |||
Excel VBA macro - need to edit code to skip a year | Excel Programming | |||
skip code | Excel Programming | |||
Excel skip some lines of VBA code | Excel Programming |