0

I'm using a custom function that I found here to retroactively set values in other cells based on new information in later cells. The issue is, however, that the input of SetCellValue is a cell reference in quotes, like this:

SetCellValue("G3",16)

I need a way that I can change the reference in quotes (G3 in this example) to whichever cell I need to work with. I've tried using different logical tests and concatenation to no avail. I'm also going to be working with a very large set of data, so manually changing the references is pretty unfeasible. Any ideas?

Brandon Sipe
  • 1
  • 2

1 Answers1

0

Say you want it to refer to cell H1. Try replacing "G3" (from your example in question) and put =H1 (try with and without quotes)

7r4c0r
  • 321
  • 3
  • 5
  • Doing that does write the value to H1, but it still doesn't allow me to dynamically change it when I autofill across several columns/rows. It also still has to be in quotes. – Brandon Sipe Jun 14 '18 at 19:37