One way
![]()
Sub test() With Range("h1", Range("h" & Rows.Count).End(xlUp)) .Value = Evaluate("if(" & .Address & "<>"""",if(isnumber(" & _ .Address & "),round(" & .Address & "*1.8,1)," & .Address & "),"""")") End With End Sub
One way
![]()
Sub test() With Range("h1", Range("h" & Rows.Count).End(xlUp)) .Value = Evaluate("if(" & .Address & "<>"""",if(isnumber(" & _ .Address & "),round(" & .Address & "*1.8,1)," & .Address & "),"""")") End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks