Hi
I am trying to find a way of testing 10 different sized ranges in VBA to see if there are ANY blank cells. The ranges are based on periods of time which increase in their row count as the combobox value selected by the user increases towards 10.
On the worksheet one the columns contains input for financial data and if the user has selected say 6 in the combo their are 6 rows of financial data they have to enter, say C1:C6, if they had selcted 2 then the required financila entry would be C1:C2 etc.
I am trying to catch missing entries from a comand button before the range values are used elsewhere in the sheet calculation with case select construct but without a great deal of success, none in fact.
I could post my code but I've just been thrashing about so I doubt whether it would be at all instructive. But as psuedo code it would look something like this
Apart from the error I am getting I am fairly certain my method is wrong particuarly the .select so any push in the right direction wouldbe appreciated.
many thanks
Bookmarks