Forum Discussion
Gary W
Sep 21, 2017Copper Contributor
Modifying a "sample" Excel "Movie List" spreadsheet
I've attempted to look up solutions on the WEB but haven't found one that has worked for what I'm attempting to accomplish. Need help, I'm so confused, and it's been at least 15 years since I took Ex...
Gary W
Sep 25, 2017Copper Contributor
Sergei,
I checked it out and surprisingly quite a bit of it was familiar.
The only function that was't familiar was the "If Not" statement...looked really weird, seemed sort of counter productive if you know what I mean! lol...I'm used to "If", "Then", but I can't remember ever seeing "If Not", go figure.
I just don't know how to translate it to Excel
I really need to get my books out of storage and get back to the level of understanding I once had.
Thanks
SergeiBaklan
Sep 25, 2017Diamond Contributor
simply google "VBA if not" and you'll find a lot of references. Here is almost complete guide for using If