Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a code that replaces anything in the column with a "+" with the column
heading name, however I cannot get the code to move to the next column and do the same thing. Can anyone help Sub InsertRow() Application.ScreenUpdating = False lrow = Range("A" & Rows.Count).End(xlUp).Row For i = lrow To 2 Step -1 c = 12 If Cells(i, c).Value Like "*+*" Then Cells(i, c).Value = Cells(1, c) Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy 1 document and when original updated copy is also | Excel Discussion (Misc queries) | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |