Someone please help. I need to write a macro that will allow me to paste special, "values" for multiple selctions? In other words, I have a sheet that has about 5 sections that are color coded in yellow and this is where I do a Vlookup to get all the data. Once the data is filled in, I need to just run a macro that will take all the cells within the yellow highlighted section and change them to the value in the cell (removing the formula) like a paste special values? The problem is that I have to do it one row at a time because Excel wont let me paste special for multiple selections? Is there a way around this? The rows are not simulateous and I have to scrol through a long sheet and highlight the rows one by one and then do a paste specail one by one. Im killing myself slowly!! Please help!!
|