$$Excel-Macros$$ Populate Values over a range

2013-09-12 Thread Hilary Lomotey
Hello Experts in the attached i have a marco that puts in values over an active cell. However if i select a range of either non-contiguous range or contiguous range i cant get it to populate over the selected range. pls can anyone assist with code. thanks -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Populate Values over a range

2013-09-12 Thread De Premor
Try to use Selectionistead of ActiveCell Selection.Value = Please assist with code Pada 12/09/2013 18:36, Hilary Lomotey menulis: Hello Experts in the attached i have a marco that puts in values over an active cell. However if i select a range of either non-contiguous range or contiguous

Re: $$Excel-Macros$$ Populate Values over a range

2013-09-12 Thread Hilary Lomotey
Yes, thanks thats exactly what i needed. thanks so much On Thu, Sep 12, 2013 at 12:42 PM, De Premor d...@premor.net wrote: Try to use Selection istead of ActiveCell Selection.Value = Please assist with code Pada 12/09/2013 18:36, Hilary Lomotey menulis: Hello Experts in the