G
Guest
Trying to make a check for users to indicate which cells still require input,
when they think they are done.
Rows not required at this point will be hidden already.
The rows to be checked are then obviously NOT hidden.
The cells that require input are unlocked (alway yellow) and "empty"
I'd like these cells to be somehow "changed" ie: pattern - assuming that the
following, which is part of my printing code, will not remove the pattern.
Cells. Select
Selection.Interior.ColorIndex = -4142.
Then, the code should step thru all the "empty" (blank?) cells, starting in
C6, ending at bottom right (E?), allowing them the possibility of entering
data in each of the empty cells (hopefully). The entry of data in a cell
should automatically remove the pattern.
I hope this is understandable.
Input greatly appreciated, as always.
Sub MissingInfo()
Dim ws As Worksheet
Set ws = Worksheets("Pricing")
Dim LLastRow As Long
Dim c As Range
' Determine last row, using column B
LLastRow = ws.Range("B:B").SpecialCells(xlCellTypeLastCell).Row
With ws.Range("C6:E" & LLastRow)
' Put a pattern in the unlocked empty cells in columns C6, thru E ?.
' (Could be, in 1 row, Columns C, and/or D, and/or E or any combination
thereof)
' Then, starting at C6, go to first empty, unlocked cell and stop.
' User can input data ( or not ). When Enter selected, steps to next empty,
unlocked cell. etc..............
' Input of data will remove pattern from cell.
' Step thru should be from Top, and alway Left to Right, in each
applicable row
when they think they are done.
Rows not required at this point will be hidden already.
The rows to be checked are then obviously NOT hidden.
The cells that require input are unlocked (alway yellow) and "empty"
I'd like these cells to be somehow "changed" ie: pattern - assuming that the
following, which is part of my printing code, will not remove the pattern.
Cells. Select
Selection.Interior.ColorIndex = -4142.
Then, the code should step thru all the "empty" (blank?) cells, starting in
C6, ending at bottom right (E?), allowing them the possibility of entering
data in each of the empty cells (hopefully). The entry of data in a cell
should automatically remove the pattern.
I hope this is understandable.
Input greatly appreciated, as always.
Sub MissingInfo()
Dim ws As Worksheet
Set ws = Worksheets("Pricing")
Dim LLastRow As Long
Dim c As Range
' Determine last row, using column B
LLastRow = ws.Range("B:B").SpecialCells(xlCellTypeLastCell).Row
With ws.Range("C6:E" & LLastRow)
' Put a pattern in the unlocked empty cells in columns C6, thru E ?.
' (Could be, in 1 row, Columns C, and/or D, and/or E or any combination
thereof)
' Then, starting at C6, go to first empty, unlocked cell and stop.
' User can input data ( or not ). When Enter selected, steps to next empty,
unlocked cell. etc..............
' Input of data will remove pattern from cell.
' Step thru should be from Top, and alway Left to Right, in each
applicable row