| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select ranges of data with a macro
I have formulas in Q5 TO AB20 with a sum formula running from Q21 TO AB21,
someone inserts a new row at the end of the selection of data so the data range is Q5 TO AB21, however the sum formula doesn't include the new row. I wanted a macro to select the data from Q5 TO AB21 and auto fill with the formulas. Next day someone adds another row and the data range is now Q5 TO AB22. And so on. Any ideas? Cheers Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select Range to protect and unprotect ranges | Excel Worksheet Functions | |||
| macro to search for & select ranges to sum | Excel Programming | |||
| How to write a macro to select print ranges that vary monthly | Excel Programming | |||
| in charting, how do i select data ranges from multiple sheets, sa. | Charts and Charting in Excel | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
![Simon - M&M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
