ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
Two random numbers, y and z, are generated in my VBA as follows:
Randomize
y = Application.RandBetween(1, 8)
Randomize
z = Application.RandBetween(1, 8)
I want cell F18 to show a sentence with a cell address in it that adds 69 to y and 6 to z. I know what I have below is incorrect, but can it be adapted to VBA? Thanks.
Range("F18").Value = "Enter your answer in cell "&ADDRESS(69 + y, 6 + z, 4)
Randomize
y = Application.RandBetween(1, 8)
Randomize
z = Application.RandBetween(1, 8)
I want cell F18 to show a sentence with a cell address in it that adds 69 to y and 6 to z. I know what I have below is incorrect, but can it be adapted to VBA? Thanks.
Range("F18").Value = "Enter your answer in cell "&ADDRESS(69 + y, 6 + z, 4)