I have a VBA variable, x, whose value is the address I want to put in an Excel spreadsheet formula. Does anyone know how to do this
Thanks,
Ken
Visual Basic for Applications (VBA)
I have a VBA variable, x, whose value is the address I want to put in an Excel spreadsheet formula. Does anyone know how to do this
Thanks,
Ken
range(x).formula = "=rand()"
re-reading you might mean
range("A1").formula = "=" & x