So I'm a novice to VBA, used Excel for years self taught but trying to get my head around VBA coding.
I have written for a work delivery spreadsheet to send out automated texts when dispatching an order. However there are several references to cell numbers in the code (E8, M8, B8, K8) and I need to be able to change these for each button working down my spreadsheet.
I have about 50 per sheet & 5 sheets to do so looking for the fastest and easiest way to replicate the code without having to do 250 individual buttons & code.
Any help and advice is greatly appreciated.
Bookmarks