The Idea Dude
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 591
- Office Version
- 2016
- Platform
- Windows
OK, here is some of my code.
Basically i am choosing that z1 will give me the value in the cell that is the same col as active cell, but in row 4. So if active cell was D10, then z1 would equal the value that is in cell D4
Thank you
Dim x
x = ActiveCell.Column
Dim y
y = ActiveCell.Row
Dim z1
z1 = x4.Value
Basically i am choosing that z1 will give me the value in the cell that is the same col as active cell, but in row 4. So if active cell was D10, then z1 would equal the value that is in cell D4
Thank you
Dim x
x = ActiveCell.Column
Dim y
y = ActiveCell.Row
Dim z1
z1 = x4.Value