I am looping through a range in Col A, and need to skip any cell not containing a date. Can someone please suggest a conditional statment in VBA which will allow this? I'm attaching Workbook illustrating the setup. Many thanks for all help.
I am looping through a range in Col A, and need to skip any cell not containing a date. Can someone please suggest a conditional statment in VBA which will allow this? I'm attaching Workbook illustrating the setup. Many thanks for all help.
nothing attached. Please read the banner at the top of this page on how to attach.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
OK, I tried again. Sorry for the omission the first time.
For starters, the sheet you provided does not have any valid dates. All entries in column A are Text. Is this how your actual data is presented? Do you wish to test this data by first converting the data in Column A to date format? Perhaps we need a bit more of an explanation. What should happen if a cell in Column A is found to be a date?
This is how the data is presented, and the long strings are meant to be dates. There are only 3 possibilities for entries on column A:
1.- The cell contains a date as text.
2.- The cell is blank
3.- The cell contains the string "Exp".
I need to be able to skip 2.- and 3.- in the loop. Maybe the easiest way to do it would be to include only those cells longer than, say, 5 characters?
I appreciate your help.
Please Login or Register to view this content.
Great, simple and effective. Appreciate your expertise and patience.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks