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?
Configuration: Windows XP Internet Explorer 6.0
Add "one column" excel Add numbers in two columns of cells excel Combine "one column" excel Convert single column to columns excel Excel alt enter text to column Excel macro compare columns Excel macro compare columns between two worksheets Excel macro match columns Excel macro to update one column Hide column excel using mark How to apply a macro to column excel Insert "one column" excel Match columns excel Ms excel macro to read a column in worksheet Multi page macro code in excel vba Pasting in one column excel Return the values of the same values in different columns excel Unique record filter multiple columns excel