Search:

Type: Posts; User: AlanBP; Keyword(s):

Search: Search took 0.01 seconds.

  1. Re: Converting conditional format references in macro (Excel 97/2k)

    Thanks Hans, that did it. I had been looking in the help under Offset(), but had not thought to look under Address(). Once you pointed it out, it became plain when looking at the help.
    Thanks
    Alan.
  2. Converting conditional format references in macro (Excel 97/2k)

    I have a problem with formulae in conditional formats when I sort the data in a sheet. The conditional format macro is along the lines of Formula1:="=MIN(" & r1.Address() & ":" & r1.Offset(0,...
Results 1 to 2 of 2