| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why won't this work???
i have a macro that won't insert the value from the offset. it just inserts
the word "here". i need the value from "here" Sub fourteenftauto() Dim here As String here = ActiveCell.Offset(0, -7).Value ActiveCell = "=sumif(b1:b1000,here,h1:h1000)/168" End Sub -- Thank You in advance, Zab |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
| If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
