Hi, as stated in title, I need to macro an inputbox to let me select cells instead of prompt me to enter cells.
For example, I need to select cells in column P, but number of rows is different everytime, eg. sometimes I want P10:P11 or P10,P12,P14....
my current code just allow me to enter cells, how should I modify the code to select the cells instead of typing it?![]()
x = InputBox("Enter changing cells, for example: $P$10,$P$11", "Changing Cells", "$P$10,$P$11")
Thanks for any replies!!!!![]()
Bookmarks