| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting data based on a cell range
I think your endrow is
range("C65536").end(xlup).row "tarns" wrote: How would to insert a formula to sum up all data in the current range if it matches a value without hardcoding a large number like the 1000th row of column C ?? Code: -------------------- Sheets("List").Select ListRowCount = ActiveSheet.UsedRange.Rows.Count 'Unfiltered Data. Sheets("Complete Issues").Activate Range("D7").Formula = "=COUNTIF(List!C3:C1000,C7)" ' I Wish to use something like to select a dynamic row range based on a variable .... "=COUNTIF(List!(Range("C3")(C,ListRowCount)),C 7)" ???? OR something like.... StartRow = 3 EndRow = Cells(ActiveSheet.UsedRange.Rows.Count, "C").End(xlUp).Row But i need help cos it dont work. -------------------- -- tarns ------------------------------------------------------------------------ tarns's Profile: http://www.excelforum.com/member.php...o&userid=32291 View this thread: http://www.excelforum.com/showthread...hreadid=520437 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data bar conditional formatting based on another cell | New Users to Excel | |||
| Formatting a cell based on other cells' data | Excel Worksheet Functions | |||
| Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| Reference Data Range based on cell contents | Charts and Charting in Excel | |||
Hybrid Mode
