SlinkRN
Well-known Member
- Joined
- Oct 29, 2002
- Messages
- 724
Hi all! I usually use A1 reference style in my vba code but for the process I am about to do, it would really help to be able to use R1C1 so that I can use numbers for both the column and the row. I'm sure this is really simple, but I've been searching and trying things and still can't seem to figure it out.
I will be having 2 variables called Week and Team. The Week variable be the row number and the Team variable will be the column number. Once I have those two variable filled with, for example, 32 and 8, how do I then put a number in the cell that corresponds to R32C8 rather than using
Sheets("Schedule").range("H32") = 1
which is my usual way of doing it.
I would really love to be able to use my variables in the R1C1 reference also but I'm not sure if that's even possible. Something like "R & Week & C & Team" which would put the number one in R32C8
Thanks, Slink
I will be having 2 variables called Week and Team. The Week variable be the row number and the Team variable will be the column number. Once I have those two variable filled with, for example, 32 and 8, how do I then put a number in the cell that corresponds to R32C8 rather than using
Sheets("Schedule").range("H32") = 1
which is my usual way of doing it.
I would really love to be able to use my variables in the R1C1 reference also but I'm not sure if that's even possible. Something like "R & Week & C & Team" which would put the number one in R32C8
Thanks, Slink