Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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).R ow 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Empty cells showing that they are default formated to "Date" | Excel Discussion (Misc queries) | |||
Cannot find "Plot empty cells as" option in 2007 | Charts and Charting in Excel | |||
The rows have been moved to smallest possible and are "hidden" | Excel Discussion (Misc queries) | |||
syntax for "IF" commend to check for multiple empty cells bf comma | Excel Worksheet Functions | |||
"ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) |