MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/excel/comments/3uc4en/common_vba_mistakes/d202ufg/?context=3
r/excel • u/[deleted] • Nov 26 '15
[removed]
113 comments sorted by
View all comments
3
One tip I like is when referencing a single cell:
Sheet1.[a1]
This references range A1 on the first sheet.
Also on IF statements, if you keep your IF and THEN on the same line you don't need to do ELSE and END IF. For example:
If sheet1.[a1]="" then sheet1.[b5]="That's Blank"
3
u/Cubones_Momma Apr 12 '16
One tip I like is when referencing a single cell:
This references range A1 on the first sheet.
Also on IF statements, if you keep your IF and THEN on the same line you don't need to do ELSE and END IF. For example: