Macro to Add Columns in Excel

Hello,
I have a spreadsheet to track patient information. It has the potential to grow out to the right based on number of contacts made. I need to write a macro to insert 3 columns after the last column with data in it. Now- I can do that and I have done that. HOWEVER- It always inserts the columns in the exact same cell address. It's not going to the column immediately to the right of the last column with data in it. I need to give people the option to insert multiple columns for multiple records as needed. But the way I have the macro running right now, no matter how many times I run it- it inserts the columns in the same spot and would overwrite anything that was in there. I tried hitting the Ctrl and right arrow to get to the cell after the last bit of data and it still doesn't help. Any ideas?! Is it possible?