| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last blank row and use in a formula
I have been trying to write a formula to a cell for hours and can't seem to
get it to work. I need to do the following: Find the last blank row set cell C2 with COUNTIF($b$2:$b$ lastblankrow,A2) Copy the formula down from C2 until the last blank row (haven't gotten that far yet) Below is one of the many many ways I've tried this unsuccessfully. Can someone help me? Thanks. Set LastRowTemp = Cells(Rows.Count, 1).End(xlUp)(2).Row Worksheets("DuplicateParts").Range("C2").Formula = "=CountIf(Range("B2:B & LastRowTemp"),Range("A2"))" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
| How Do I find/replace a blank cell with a formula? | Excel Worksheet Functions | |||
Threaded Mode
