| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding formulas to blank cells
In VBA, for all blank cells in one column of the current region of the active sheet, I want to add a formula that will put in the value of the cell immediately above the blank cell. The current region is different for each sheet in the workbook. Any ideas? Thanks. -- jerrystan ------------------------------------------------------------------------ jerrystan's Profile: http://www.excelforum.com/member.php...o&userid=28573 View this thread: http://www.excelforum.com/showthread...hreadid=482355 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding formulas to blank cells
Are you going to be selecting this region? or is it like Column A? can help you write the code, just need more info... jerrystan Wrote: In VBA, for all blank cells in one column of the current region of th active sheet, I want to add a formula that will put in the value of th cell immediately above the blank cell. The current region is differen for each sheet in the workbook. Any ideas? Thanks -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=48235 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells with formulas | Excel Worksheet Functions | |||
| Adding cells but leaving blank if not populated | Excel Worksheet Functions | |||
| Linked sheets, blank cells and adding new rows | Excel Worksheet Functions | |||
| Adding Blank Cells ? | New Users to Excel | |||
| Adding a value to blank cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
