I wonder if anyone can help me with a small (I think) problem, please?
I'm trying to write a macro to manipulate a spreadsheet sent to me by an external source. It contains a list of transactions with a summary below.
In order to format the summary in the way I want, I need to unmerge the cells it appears in.
I'm trying to put in something like:
x = InputBox("How many transactions?")
but it's not working.
Many thanks for anyone's suggestions on how I could do this instead,
A Macro Newbie.