In K5 I have a simple randbetween, concatenation and vlookup formula that results in a grid reference, like G3.
I'd like to add a simple button that when pressed will run a macro that does two things ...
1) changes the grid reference (ie: activates the cell to run the formula again).
2) records in column AB what grid references have appeared in cell K5, ie: from B1 downwards.
My VBA is very poor.
Is this possible ?
Kind regards,
Chris
I'd like to add a simple button that when pressed will run a macro that does two things ...
1) changes the grid reference (ie: activates the cell to run the formula again).
2) records in column AB what grid references have appeared in cell K5, ie: from B1 downwards.
My VBA is very poor.
Is this possible ?
Kind regards,
Chris