Results 1 to 10 of 10

Macro problem for absolute reference

Threaded View

  1. #9
    Forum Contributor
    Join Date
    04-29-2011
    Location
    South Korea
    MS-Off Ver
    Excel 2019
    Posts
    178

    (solved) Re: Macro problem for absolute reference

    Dear Watersev,

    Thanks thanks for your reply. It is so awesome. I don't think I can get better answer from forum.

    Sub Absolute()
    Dim cell As Range
    With Application: .ScreenUpdating = 0: .Calculation = xlManual
    For Each cell In Selection
        If cell.HasFormula Then cell = Application.ConvertFormula(cell.Formula, xlA1, , xlAbsolute)
    Next: .ScreenUpdating = 1: .Calculation = xlCalculationAutomatic: End With: End Sub
    May I know which vba knowledge used in this macro (looping)? I tried to search in the web site, still can't get the solution. It seems that you develop the macro by yourself.
    Last edited by ronlau123; 07-18-2011 at 01:23 AM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1