I am trying to create VBA code to count the number of cells within a range that have either text or numbers entered in them.
This needs to work on a row by row basis, i.e. the same code applied to row 6, 7, 8 onwards.
I have 12 cells in a
row range that are being written into the spreadsheet using another code.
The activecell is set as a cell in
The 12 cells (labelled 'Deployments') are found in columns AL:AW and are being written using the codes
c.Offset(0, 36).Value = .TextBox_Deployment1.Value
c.Offset(0, 47).Value = .TextBox_Deployment12.Value
How do I create a countif code that is able to reference these values?
Can post a sample worksheet if it helps.
Alternatively, the worksheet can be found under a previous thread