| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.cells question
I have this formula:
..Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 9)).FillDown cStartRow=12 and nRows=counter that counts the number of rows. 9=column. I want to use this formula for column 9 through 15. I could repeat formula 7 times and change the column number but surely there is a better way! Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.cells question
Hi
This should do it (untested) ..Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 15)).FillDown Regards, Per "Mona" skrev i meddelelsen ... I have this formula: .Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 9)).FillDown cStartRow=12 and nRows=counter that counts the number of rows. 9=column. I want to use this formula for column 9 through 15. I could repeat formula 7 times and change the column number but surely there is a better way! Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.cells question
dim iCol as long
for icol = 9 to 15 'do what you want... .range(.cells(cstartrow,icol),.cells(cstartrow+nro ws,icol)).filldown next icol Mona wrote: I have this formula: .Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 9)).FillDown cStartRow=12 and nRows=counter that counts the number of rows. 9=column. I want to use this formula for column 9 through 15. I could repeat formula 7 times and change the column number but surely there is a better way! Thanks in advance! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.cells question
perfect!!
"Per Jessen" wrote: Hi This should do it (untested) ..Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 15)).FillDown Regards, Per "Mona" skrev i meddelelsen ... I have this formula: .Range(.Cells(cStartRow, 9), .Cells(cStartRow + nRows, 9)).FillDown cStartRow=12 and nRows=counter that counts the number of rows. 9=column. I want to use this formula for column 9 through 15. I could repeat formula 7 times and change the column number but surely there is a better way! Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| < question for multiply cells. | Excel Worksheet Functions | |||
| Excell named cells or labeled cells question | Excel Programming | |||
| Excel named cells or labeled cells question | Excel Programming | |||
| Find cells question ? | Excel Programming | |||
| Question On Formatting cells | Excel Programming | |||
Linear Mode
