katralic
12-19-2015, 07:59 PM
I'm new to macros. Only about 2 months into it but I've been able to do pretty much everything I've wanted except 1.
Heres the setup
cell A1 this cell has a cell address in it
cell A2 this cell has a number in it
example
A1 R32C54
A2 536
ok I make all my macros as a button.
All I want to be able to do is hit the button and the macro will take the number from A2 which in this example is 536 and input into the cell location R32C54
Seems simple but heres the catch
The cell address listed in A1 will always be different. Once its used it will not be used again.
The next time I run it the address might be R543C128 etc
I can easily enough input the number from A2 into it once I get there but I haven't been able to figure out how to get the macro to go the address listed. It is not predictable. The cell address is dependent on other parts of the spreadsheet.
Cell A1 is just telling me where the number in A2 needs to go. I can do it manually quick enough but when I try to record the macro it doesn't work. I copy the A1 location and input it into the search bar and hit enter. it goes to the location and I type in the number from A2. Very simple. The macro will not record the pasting of A1 into the search bar. Ive read many pdf files trying to find an example and I'm beginning to think that its not possible but that's hard to believe with all the things VBA can do. HELP ME PLEASE its driving me nuts
Heres the setup
cell A1 this cell has a cell address in it
cell A2 this cell has a number in it
example
A1 R32C54
A2 536
ok I make all my macros as a button.
All I want to be able to do is hit the button and the macro will take the number from A2 which in this example is 536 and input into the cell location R32C54
Seems simple but heres the catch
The cell address listed in A1 will always be different. Once its used it will not be used again.
The next time I run it the address might be R543C128 etc
I can easily enough input the number from A2 into it once I get there but I haven't been able to figure out how to get the macro to go the address listed. It is not predictable. The cell address is dependent on other parts of the spreadsheet.
Cell A1 is just telling me where the number in A2 needs to go. I can do it manually quick enough but when I try to record the macro it doesn't work. I copy the A1 location and input it into the search bar and hit enter. it goes to the location and I type in the number from A2. Very simple. The macro will not record the pasting of A1 into the search bar. Ive read many pdf files trying to find an example and I'm beginning to think that its not possible but that's hard to believe with all the things VBA can do. HELP ME PLEASE its driving me nuts