| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hardcode a column in a formula
That did the trick...Thanks so much!
Bernie Deitrick wrote: AHizon, With Cells(Rows.Count, lCol).End(xlUp) .Offset(1, 0).Formula = _ "=SUM(" & Range(Cells(2, lCol), .Cells(1, 1)).Address & ") - C2" End With HTH, Bernie MS Excel MVP How do I hardcode a column in a formula? Currently I have the following but [quoted text clipped - 18 lines] the left of the cell with the formula. Any assistance would be appreciated. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Month formula from column to column | Excel Discussion (Misc queries) | |||
| formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Hybrid Mode
