The cells I am trying to reference are in a sheet called interface. In this example, i am trying to use values in cells E37 and E39 to reference Ax and Hy where x and y are the respective values of cells E37 and E39 in sheet "Interface"... Why doesn't this work or how can i make it work?
Range("A" & [Interface!$E$37] & ":" & "H" & [Interface!$E$39]).Select
Thanks!
Range("A" & [Interface!$E$37] & ":" & "H" & [Interface!$E$39]).Select
Thanks!