bobkap
Active Member
- Joined
- Nov 22, 2009
- Messages
- 323
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
This line of code (below) is NOT working as a normal IF statement. If I include the "End If" line I get an error message. I also get an error if I try to use a line starting with "else". I need the functionality of a regular IF statement so I can apply code for those situations where my cell does not include a date.
Any suggestions, explanations or ideas would be most appreciated.
"If IsDate(Cells(bkrow, 1)) Then ActiveWorkbook.Sheets.Add Before:=Worksheets(Worksheets.Count)"
Any suggestions, explanations or ideas would be most appreciated.
"If IsDate(Cells(bkrow, 1)) Then ActiveWorkbook.Sheets.Add Before:=Worksheets(Worksheets.Count)"