iloop

Hi, I have very unique problem here and from past 2 days I searched the answer in google or asked with some other VAB expert but I could not get a answer, please kindly help me to resolve this problem. Problem:- I have multiple footnotes (footnote cells C21, C44, C120, C178 etc.,) in a excel...

I have sheet tabs name by the year. Only 1 sheet tab will be visible. All other tabs will be hidden. The code below will populate the userform with years (i.e. 2019, 2018, 2017, etc). My current sheet tab (2018) is visible. I would like the combo box to not display the year in the combo box...

My workbook sheet tabs would be named by Year (i.e. 2018, 2019, etc). Currently I have one sheet (i.e. 2019). I would like to display in a combo box the previous 2yrs (i.e. 2018 & 2017) and also the following year (i.e. 2020). Maximum years displayed should be limited to 4. (i.e. 2017 -...

Hi guys I'm getting a 1004 error with the following code. I've just looked a second ago at this variable = Lastcell. I used a message box and it seems to be empty. Any advise would be great guys. My brain is killing me here. Thanks Option Explicit Sub FullFatGen() Dim...