| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of rows and apply formula
I eventually solved this with ...
Private Sub Worksheet_Activate() Dim LastRow As Long LastRow = Sheet1.Cells(Cells.Rows.Count, "A").End(xlUp).Row Sheet2.Range("A2:R" & LastRow).FillDown End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I apply a formula to multiple rows at the same time? | Excel Worksheet Functions | |||
| setting a formula to apply to all rows in a column | New Users to Excel | |||
| formula to apply concatenation to successive rows of data | Excel Worksheet Functions | |||
| apply formula to other rows ... | Excel Discussion (Misc queries) | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
![Grey Old Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
