Forum Discussion

bwy1129's avatar
bwy1129
Copper Contributor
Mar 27, 2022
Solved

I Need help designing a LET() function properly.

My problem revolves around creating a range, using variables provided by the LET() function, to create a proper range for a MAX() function. The variables are row numbers. Background: I weigh mysel...
Formulas and Functions
  • Starrysky1988's avatar
    Starrysky1988
    Mar 27, 2022
    Why don't you use Indirect function.
    =Max(Indirect("Meter!D6:D"&RowIDnow)
Starrysky1988's avatar
Starrysky1988
Iron Contributor
Mar 27, 2022
Why don't you use Indirect function.
=Max(Indirect("Meter!D6:D"&RowIDnow)
bwy1129's avatar
bwy1129
Copper Contributor
Mar 27, 2022
This is why I come to you guys! I've been in IT for over 40 years. (I still remember Radio Shack Model I computers with cassette tape storage), but I've crammed my head so full of system "things" that I have forgotten most of my VBA techniques. (Of course, it can't be MY or San Andreas' fault, so let's blame it on Mr. Alzheimer.)

That worked perfectly (after I added the final close_parenthesis). 😉

Resources