Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move formulas to a different column
I have a lot of cells with formulas in Column J. I would
like to move any cell that has a formula to Column L. The formulas are all over the place and are not contiguous. Moreover, the cells that have formulas are also formatted. Is there any way to identify cells that have formulas in the range (J2:J1600) and move those to the appropriate cell in column L |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
move formulas to a different column
set rng = Range("J2:J1600").SpecialCells(xlFormulas)
for each cell in rng cells(cell.row,"L").formula = cell.formula cell.ClearContents Next -- Regards, Tom Ogilvy "indu aronson" wrote in message ... I have a lot of cells with formulas in Column J. I would like to move any cell that has a formula to Column L. The formulas are all over the place and are not contiguous. Moreover, the cells that have formulas are also formatted. Is there any way to identify cells that have formulas in the range (J2:J1600) and move those to the appropriate cell in column L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
copying formulas forward and have the column refference move backw | Excel Worksheet Functions | |||
freezing formulas when cells move | Excel Worksheet Functions | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) |