Hence why I put #n/a as the text value produced if date matches.
My Excel tool performs a long task, and I'm trying to be kind to the user by providing a progress report in the status bar, or in some cell in the sheet, as shown below.
For instance, any keys pressed while a function is running will be sent by Do Events The keyboard input will be processed before the screen is updated, so if you are changing cells on a spreadsheet by holding down one of the arrow keys on the keyboard, then the cell change event will keep firing before the main function finishes.
I've found in the many long Excel calculations most of the time waiting is having Excel update values on the screen.
Hope this clarifies and thank you so much for your help! Hence the macro searches H3 to CU3 for first blank from cell G3.
Also No the first blank cell along each row is nearly always different. However any of the cells in column B, E, F, G may also contain blanks.
Number of rows may expand, but probably wouldnt exceed 150 if it does expand. Find(What:="*", Search Order:=xl Rows, Search Direction:=xl Previous, Look In:=xl Values). Areas(1)(1) = "=IF((INDIRECT("RC[-3]",0))=(VLOOKUP($D:$D, Pivots! Vb is expecting an end to the statement here instead of at the very end... Areas(1)(1) = "=IF((INDIRECT("RC[-3]",0))=(VLOOKUP($D:$D, Pivots! Vb is expecting an end to the statement here instead of at the very end... Internal quote marks must be doubled up when inside a quoted text string, but I don't think that is the only thing wrong with your formula...
As you can see, for each row the first blank found after the first planned date may/may not be different for every row (in red) Row5 for example where no Planned Date 1 is entered currently (col G, blue highlight) should be skipped because there will be no actual data returned by the vlookup. Currently im updating this manually and it takes hours to check 129 rows individually. Row On Error Go To No Blanks Set Blanks = Range("H3: CU" & Last Row). you cannot mix R1C1 notation with A1 notation inside a formula and you cannot produce a #N/A error using just those characters, rather, I think you would need to use the NA() function call instead. C3: C4,2, FALSE))" I'm going to sleep for the night, so I won't be able to check back into here for awhile...