Hi,
I have a workbook, consisting for 5 sheets (110, 220, 100, 200, 400). I have created a code to compile information automatically into the respective sheet according to their category. For instance, I have this information for sheet 110 and I run the code to compile the information into that particular sheet. This information goes into row 18. Next, I need to N/A all the blank cells in that row in sheet 110. Following that, I have another set of information to be entered into sheet 110, into the next row, which is sheet 19. After that, N/A all blank cells before moving on to key in information into the next row.
What code should I write for to get my N/A included in next row, in that particular sheet?
This is my current code for N/A. But this code affect my previous rows (ie, my headers got N/A as well). Can I have some help here too?
Thank you.
I have a workbook, consisting for 5 sheets (110, 220, 100, 200, 400). I have created a code to compile information automatically into the respective sheet according to their category. For instance, I have this information for sheet 110 and I run the code to compile the information into that particular sheet. This information goes into row 18. Next, I need to N/A all the blank cells in that row in sheet 110. Following that, I have another set of information to be entered into sheet 110, into the next row, which is sheet 19. After that, N/A all blank cells before moving on to key in information into the next row.
What code should I write for to get my N/A included in next row, in that particular sheet?
VBA Code:
Sub FillEmptyCells()
'Forces each cell to show N/A if Empty
On Error Resume Next
Dim lastrow As Long
Range("A18").CurrentRegion.SpecialCells(xlBlanks).Value = "N/A"
End Sub
This is my current code for N/A. But this code affect my previous rows (ie, my headers got N/A as well). Can I have some help here too?
Thank you.