Hi All,
I'm a relative VBA newbie, so please bear with me....
After learning the joys of looping in VBA, I have since realised (Translation: read online) that there are nearly always far more efficient ways of doing things than looping.
I have a macro that loops through all cells in column A and multiplies the values in column B by '-1' if it meets a specific criteria. I now realise it is far more efficient to copy the value '-1' then use the auto-filter, GoTo visible cells only, then paste special - multiply.
I can't figure out how to do this in VBA though (I assumed it would be fairly simple for some reason , so maybe I'm just missing something).
Is anyone able to point me in the right direction?
I ran a search on this site, but only came up with the following threads:
http://www.mrexcel.com/forum/showthread.php?t=482675&highlight=vba+visible+cells+paste+special
http://www.mrexcel.com/forum/showthread.php?t=85288&highlight=vba+visible+cells+paste+special
Thank you in advance.
I'm a relative VBA newbie, so please bear with me....
After learning the joys of looping in VBA, I have since realised (Translation: read online) that there are nearly always far more efficient ways of doing things than looping.
I have a macro that loops through all cells in column A and multiplies the values in column B by '-1' if it meets a specific criteria. I now realise it is far more efficient to copy the value '-1' then use the auto-filter, GoTo visible cells only, then paste special - multiply.
I can't figure out how to do this in VBA though (I assumed it would be fairly simple for some reason , so maybe I'm just missing something).
Is anyone able to point me in the right direction?
I ran a search on this site, but only came up with the following threads:
http://www.mrexcel.com/forum/showthread.php?t=482675&highlight=vba+visible+cells+paste+special
http://www.mrexcel.com/forum/showthread.php?t=85288&highlight=vba+visible+cells+paste+special
Thank you in advance.