Can I record a macro on a cell that has text but not a text box
I want to record a macro that contains names from A6 down to A255. I need
each cell when clicked to go to Sheet 'A' on the corresponding name going
from D6 to IS6. Is there any way I can do this? If I make a text box, I can
use that to record the macro, but I have a CountA to count if the cell is
empty or not. I do not get the option to record macros. You help would be
welcomed. Thanks.
Bryan.
|