I created a macro to load the Unique Numbers,
then I created a Change Event to run the macro whenever a change takes place
in the target area:
-
Option Explicit
Public Dict_Val
Sub Load_Data()
Dim R, C, Rcnt, dKeys, tV
Thanks Ashish but blank cell is coming in the middle of the column.
On Tue, Jan 11, 2011 at 10:57 AM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Tue, Jan 11, 2011 at 12:19 AM, Sundarvelan N wrote:
>
>> Hello Friends,
>>
>> Can anybody help me to achieve my task.
>>
>> In
