Hello!
I'll try my best to describe my issue.
My boss told me to create Excell Spreadshit that calculates statistics (F2, rsd, etc.) from filled cells but not empty ones.
E.g. you can enter any amount of data but calculation will use only cells with info.
If you use simple formula, you have to specify range to be used. I want to eliminate this so range is infinite but empty spaces are not counted.
Do you recommend to stop macro at last filled cell or before first empty cell? And how to make it calculate stuff from those filled cells?
Please, help, I'm new to VBA
Thank you
Bookmarks