User Profile
AE7888
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
VBA code that moves to a variable address that is contained in an ADDRESS formula
I have cell (say C1) that contains an exact address (say $F$20 for example) using the ADDRESS function. I would like VBA code to move the cursor to that address. But each time the VBA code is utilized, the value in cell C1 changes to a new Address. (say $z$25 the next time), and I would like it to automatically move to the new address contained in cell C1 each time. When I try to record a macro using FIND or GOTO from the pull down menu, it only keeps the first address value ever used. It never updates to the new address. Does anyone know how to do this. Thanks,Solved2.8KViews0likes4Comments
Recent Blog Articles
No content to show