Generating Dates and random numbers at a time in excel for 1000 rows

P

purna

New Member
Joined
Mar 20, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi All,

Greetings!!

I have done with a small macro to get the random numbers as per the below script, where teh no is being generated in the cd_no column.

Sub vba_random_number()

Range("C6:c500") = WorksheetFunction.RandArray(500,1,7000,9000,True).

End Sub

But am looking for a macro in such a way where i can get the random date and random numbers from a single macro script for 500 rows

Can anyone help me on this.

Snocd_nocd_dt
1​
6296​
2000-05-22​
2​
8012​
2000-05-22​
3​
6410​
2000-05-22​
4​
6260​
2000-05-22​
5​
6522​
2000-05-22​
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
purna said:
Hi All,

Greetings!!

I have done with a small macro(below) to get the random numbers, where random numbers got generated b/w 7000 to 9000 from Sno 6. But, i am not sure how to generate the random dates .

Sub vba_random_number()

Range("C6:c500") = WorksheetFunction.RandArray(500,1,7000,9000,True).

End Sub

Am looking for a macro in such a way where i can get the random date and random numbers at a single time from a single macro script for 500 rows

Can anyone help me on this.

Snocd_nocd_dt
1​
6296​
2000-05-22​
2​
8012​
2000-05-22​
3​
6410​
2000-05-22​
4​
6260​
2000-05-22​
5​
6522​
2000-05-22​
Click to expand...
 
Upvote 0
Perhaps in VBA where 44927 & 46019 are dates:
VBA Code: 
Sub vba_random_number()

    Range("C6:C500") = Application.RandArray(500, 1, 7000, 9000, True)
    Range("D6:D500") = Application.RandArray(500, 1, 44927, 46019, True)
    
End Sub

Or as a formula:
Book1
AB
1Rnd NoRnd Date
276732025-08-10
389132024-06-16
482892024-06-29
580442023-01-08
683992025-11-04
774402025-09-15
870212023-09-19
971142023-05-12
1079162025-10-13
1172372025-07-29
1271022023-02-03
1380762024-05-07
1488972024-03-15
1571782025-09-05
1681932023-11-27
1776262023-05-11
1883302025-12-16
1975962025-12-02
2071802023-10-07
2179992024-06-09
2270402025-12-09
2385342024-01-23
2472512025-01-24
2570022025-10-11
2677182025-07-07
2779602024-03-08
2889132025-02-24
2985352025-03-28
3086412024-10-30
3180792025-04-08
3273882024-02-21
3372522024-07-20
3475152023-05-30
3581962025-03-11
3682802024-11-20
3782522024-11-10
3872712025-09-21
3986652024-12-30
4071472024-07-30
4187752024-09-04
4284212024-03-27
4378412023-12-15
4483242024-09-14
4573132025-04-25
4687672025-05-11
4787602025-09-06
4888512023-06-03
4981972024-07-29
5070542024-09-05
5180192025-11-03
5281632024-08-14
5388322023-10-31
5477172025-03-21
5581152023-01-30
5684402025-02-13
5783302024-04-05
5876242023-06-16
5971822025-03-30
6077752023-11-24
6180672024-07-10
6282872025-09-23
6384952025-04-08
6483132025-12-09
6579092025-09-02
6680932025-06-07
6775312025-10-03
6889292025-06-21
6981102024-06-17
7078222023-01-31
7188982024-03-19
7281052025-10-23
7386962023-12-27
7475522024-01-24
7583572024-04-09
7681022024-11-06
7772972024-11-15
7877642024-11-07
7984012024-11-10
8079962024-03-18
8178212024-06-07
8270472024-02-29
8388352023-08-03
8475292023-04-08
8586302025-03-01
8682562024-03-25
8781712023-05-02
8880422024-06-12
8979782025-04-27
9073012025-06-25
9173492025-03-24
9286662025-03-24
9385862025-12-18
9476972023-10-21
9580712024-09-04
9675972024-06-24
9786022024-06-30
9887182025-03-18
9970862024-08-19
10087342025-03-24
10184172023-02-07
10287872023-05-21
10371612024-10-31
10489562024-11-21
10576062024-07-09
10685562023-03-07
10778132025-08-02
10884812024-06-20
10970412023-09-11
11077212023-07-22
11185322025-09-06
11287442025-10-28
11379052023-08-18
11479432024-05-12
11584112024-05-12
11671722025-08-31
11770092025-05-23
11875892025-12-03
11973932024-05-25
12074252025-03-19
12173262025-11-21
12270402023-02-05
12376482024-11-11
12484682023-01-18
12587452023-06-25
12678362024-05-05
12786182024-08-22
12883432024-08-28
12984732023-03-01
13083992025-06-15
13188212024-08-25
13270922023-03-27
13375622023-09-05
13470032023-07-09
13575962024-04-13
13683162023-03-30
13777712025-03-12
13874222023-01-01
13972262025-05-15
14071982024-10-09
14171502023-07-28
14271162024-09-21
14388422024-11-27
14473262024-12-29
14584812025-02-08
14672772023-09-06
14775722023-03-22
14878692023-09-10
14982752023-08-01
15070022023-03-03
15170582023-08-22
15270342023-05-18
15376302023-11-15
15488482023-01-24
15577512023-12-16
15686442025-09-25
15777982024-11-27
15876312023-08-03
15984942024-11-24
16078762023-05-28
16177212023-08-04
16274462023-07-15
16377382025-04-02
16475982025-05-25
16579142023-03-14
16670792023-12-28
16781872024-11-07
16880462025-12-28
16973432024-10-30
17070082024-08-24
17186622023-08-23
17282722023-07-23
17380162024-06-17
17481332024-10-27
17579302024-02-18
17678952024-11-14
17778712024-07-19
17883782025-03-29
17981312025-08-01
18080012025-09-19
18179972023-09-02
18270132024-06-28
18374482023-11-29
18471692024-12-10
18584482023-09-14
18683642023-10-11
18785862024-10-12
18885112023-05-18
18978132025-11-12
19086032024-05-15
19180722025-08-22
19288852024-02-29
19376912023-07-06
19479622023-04-25
19576992025-06-14
19687522024-01-18
19780722023-02-22
19872942025-09-30
19979792023-06-01
20077612023-09-18
20172672025-03-05
20275002024-10-09
20388942025-01-27
20471352025-02-20
20588582023-10-12
20687162025-03-11
20780052023-12-28
20888552023-10-14
20981692025-01-01
21074322025-12-01
21189512023-09-19
21273542024-07-28
21375182025-07-23
21484882023-02-09
21580752023-03-04
21680872023-09-18
21787282023-01-05
21889872024-01-01
21989702023-05-26
22072742023-08-01
22175792024-10-24
22277672025-02-17
22383692023-01-06
22475642025-03-08
22589702023-10-03
22671162023-09-14
22780112024-01-04
22879922024-09-04
22988842023-02-09
23088832023-10-25
23178722025-12-01
23280272025-12-25
23380592025-04-06
23472512025-01-17
23571062023-12-10
23682702025-10-12
23779752025-09-08
23870822025-01-23
23974272023-01-15
24075422025-08-20
24179582023-09-28
24272232024-11-26
24376412025-03-03
24482152024-10-04
24584182025-05-30
24687032024-04-29
24774892024-03-30
24887392024-01-18
24986842023-12-24
25079082025-04-17
25170192023-01-16
25289592025-10-06
25370542025-05-23
25471442023-04-01
25587072024-09-08
25689212025-09-21
25774512023-09-01
25883322023-12-04
25972302025-11-23
26084302023-08-12
26174992025-10-09
26274912023-12-20
26387242024-04-17
26473722023-08-24
26577062023-03-27
26672342025-02-16
26771342023-01-17
26886152023-06-06
26975672023-08-26
27072132025-12-22
27173652025-07-01
27283982023-01-23
27386802023-02-05
27488742024-02-01
27588542023-06-28
27689622025-11-12
27771332023-04-19
27873192023-02-09
27971332024-05-16
28073392024-12-12
28180142024-12-03
28283222025-06-09
28382072024-02-22
28482042025-11-13
28580262025-07-16
28675582024-12-12
28782482025-03-27
28877482024-03-14
28985362023-05-26
29074812025-04-15
29188832024-09-23
29283362024-03-23
29376672025-09-15
29476222023-04-26
29586572024-11-14
29670422023-02-19
29774822024-06-08
29888902024-02-08
29976942024-05-16
30083832024-12-21
30185402023-07-24
30278982024-04-20
30389842025-03-31
30478752025-08-13
30580422025-09-16
30672932025-04-18
30775492023-03-05
30887512025-02-21
30983772025-05-08
31071582023-07-21
31175102025-11-03
31286282024-02-25
31373972025-08-09
31470902023-02-12
31581712025-07-25
31676172024-09-30
31774672023-12-25
31882682023-01-14
31972352024-01-17
32074462023-06-29
32171102024-02-09
32278962023-08-04
32386522025-02-10
32475792024-03-01
32577142023-02-10
32688482024-03-14
32775052023-04-07
32873572024-05-16
32976032023-04-29
33078912024-09-01
33174322025-12-10
33282702023-10-13
33376352024-02-07
33488232023-03-01
33584992023-08-17
33676302025-11-12
33774882024-01-17
33884892025-04-05
33972562024-04-25
34074412023-03-11
34171932024-10-29
34271552025-12-27
34377592023-08-10
34488742024-12-13
34580202023-03-21
34676282024-11-04
34772402024-09-12
34885792025-01-17
34985672023-12-20
35080972025-10-06
35172632023-01-03
35284252024-10-22
35378932023-07-27
35483412025-08-16
35582362025-11-26
35682422024-11-21
35783082025-01-08
35883242025-01-23
35985062024-07-16
36074652024-11-04
36170462023-06-27
36276932024-09-09
36373002024-09-12
36478432024-11-05
36579132025-07-12
36672922023-05-14
36770272023-04-25
36872282024-03-10
36986232024-07-01
37074542025-01-04
37180002023-09-16
37272412024-06-22
37388602025-04-03
37482482024-09-07
37578912023-11-13
37687502023-06-22
37786182023-05-26
37873582025-02-20
37981082023-09-01
38074352024-01-13
38175612024-12-21
38282172023-02-21
38379792023-10-13
38484752024-07-21
38580312024-03-04
38674372024-10-25
38779572023-10-23
38872822024-05-19
38986472025-06-20
39080452023-08-17
39176022025-03-09
39271382024-04-08
39380552024-01-15
39485602023-12-24
39575172023-11-19
39670212024-12-26
39782442024-03-27
39887192024-06-20
39982052025-07-12
40080952023-11-30
40182072023-04-22
40282392024-09-16
40380892024-03-07
40470062024-04-06
40585712023-06-27
40678942023-03-19
40778882025-01-30
40886802024-08-19
40977502023-04-27
41076262025-04-19
41176492024-05-15
41283702024-09-18
41389512024-02-13
41487602023-07-06
41584032023-06-30
41674582025-09-06
41781332025-02-04
41878392023-06-24
41989642024-09-04
42088462025-09-15
42173272025-10-01
42278472025-05-28
42385212023-04-14
42470402024-10-15
42576212024-03-20
42672122024-12-07
42789342023-05-20
42870862023-03-31
42971832025-05-25
43085792025-02-26
43174952025-07-20
43288072023-07-31
43382642025-02-08
43484272023-08-29
43570972023-12-13
43684102025-06-25
43774532023-10-13
43886592025-07-29
43985182025-09-30
44077352023-07-30
44174122025-06-13
44282412025-09-14
44375462023-02-10
44482902023-08-21
44575072024-06-01
44678762025-02-01
44771262024-03-03
44881422024-02-05
44974792024-06-13
45083772025-03-27
45189902024-12-02
45276402024-08-14
45386242025-07-19
45488542025-03-21
45581952024-02-08
45675512023-01-10
45788392023-04-24
45875672023-09-24
45975532023-03-15
46079922025-02-02
46187362023-09-18
46271672025-10-07
46385722024-07-29
46474732025-10-26
46571982023-02-11
46682572023-05-10
46785312025-03-21
46881612025-12-03
46971012024-11-20
47076032024-09-16
47175502024-04-03
47285932025-04-14
47383042024-05-24
47489152025-02-24
47576662025-02-15
47680492023-03-11
47782572025-04-20
47873362024-05-19
47981952025-09-28
48070102025-11-27
48187042025-02-04
48281232024-08-17
48382402025-08-13
48488902025-07-19
48583792023-09-06
48675752023-02-13
48784172025-07-04
48884582024-08-03
48981872025-02-25
49077432023-04-23
49186182025-05-19
49276592025-08-23
49379552025-06-10
49483322024-05-05
49571902023-04-06
49687242025-11-20
49782732025-01-31
49875612023-10-25
49985172025-05-31
50086492023-02-26
50182172023-03-08
Sheet1
Cell Formulas
RangeFormula
A2:B501A2=LET(rNo,RANDARRAY(500,1,7000,9000,TRUE),rDt,TEXT(RANDARRAY(500,1,44927,46019,TRUE),"yyyy-mm-dd"),HSTACK(rNo,rDt))
Dynamic array formulas.
 
Upvote 2
Solution
Georgiboy said:
Perhaps in VBA where 44927 & 46019 are dates:
VBA Code: 
Sub vba_random_number()

    Range("C6:C500") = Application.RandArray(500, 1, 7000, 9000, True)
    Range("D6:D500") = Application.RandArray(500, 1, 44927, 46019, True)
   
End Sub

Or as a formula:
Book1
AB
1Rnd NoRnd Date
276732025-08-10
389132024-06-16
482892024-06-29
580442023-01-08
683992025-11-04
774402025-09-15
870212023-09-19
971142023-05-12
1079162025-10-13
1172372025-07-29
1271022023-02-03
1380762024-05-07
1488972024-03-15
1571782025-09-05
1681932023-11-27
1776262023-05-11
1883302025-12-16
1975962025-12-02
2071802023-10-07
2179992024-06-09
2270402025-12-09
2385342024-01-23
2472512025-01-24
2570022025-10-11
2677182025-07-07
2779602024-03-08
2889132025-02-24
2985352025-03-28
3086412024-10-30
3180792025-04-08
3273882024-02-21
3372522024-07-20
3475152023-05-30
3581962025-03-11
3682802024-11-20
3782522024-11-10
3872712025-09-21
3986652024-12-30
4071472024-07-30
4187752024-09-04
4284212024-03-27
4378412023-12-15
4483242024-09-14
4573132025-04-25
4687672025-05-11
4787602025-09-06
4888512023-06-03
4981972024-07-29
5070542024-09-05
5180192025-11-03
5281632024-08-14
5388322023-10-31
5477172025-03-21
5581152023-01-30
5684402025-02-13
5783302024-04-05
5876242023-06-16
5971822025-03-30
6077752023-11-24
6180672024-07-10
6282872025-09-23
6384952025-04-08
6483132025-12-09
6579092025-09-02
6680932025-06-07
6775312025-10-03
6889292025-06-21
6981102024-06-17
7078222023-01-31
7188982024-03-19
7281052025-10-23
7386962023-12-27
7475522024-01-24
7583572024-04-09
7681022024-11-06
7772972024-11-15
7877642024-11-07
7984012024-11-10
8079962024-03-18
8178212024-06-07
8270472024-02-29
8388352023-08-03
8475292023-04-08
8586302025-03-01
8682562024-03-25
8781712023-05-02
8880422024-06-12
8979782025-04-27
9073012025-06-25
9173492025-03-24
9286662025-03-24
9385862025-12-18
9476972023-10-21
9580712024-09-04
9675972024-06-24
9786022024-06-30
9887182025-03-18
9970862024-08-19
10087342025-03-24
10184172023-02-07
10287872023-05-21
10371612024-10-31
10489562024-11-21
10576062024-07-09
10685562023-03-07
10778132025-08-02
10884812024-06-20
10970412023-09-11
11077212023-07-22
11185322025-09-06
11287442025-10-28
11379052023-08-18
11479432024-05-12
11584112024-05-12
11671722025-08-31
11770092025-05-23
11875892025-12-03
11973932024-05-25
12074252025-03-19
12173262025-11-21
12270402023-02-05
12376482024-11-11
12484682023-01-18
12587452023-06-25
12678362024-05-05
12786182024-08-22
12883432024-08-28
12984732023-03-01
13083992025-06-15
13188212024-08-25
13270922023-03-27
13375622023-09-05
13470032023-07-09
13575962024-04-13
13683162023-03-30
13777712025-03-12
13874222023-01-01
13972262025-05-15
14071982024-10-09
14171502023-07-28
14271162024-09-21
14388422024-11-27
14473262024-12-29
14584812025-02-08
14672772023-09-06
14775722023-03-22
14878692023-09-10
14982752023-08-01
15070022023-03-03
15170582023-08-22
15270342023-05-18
15376302023-11-15
15488482023-01-24
15577512023-12-16
15686442025-09-25
15777982024-11-27
15876312023-08-03
15984942024-11-24
16078762023-05-28
16177212023-08-04
16274462023-07-15
16377382025-04-02
16475982025-05-25
16579142023-03-14
16670792023-12-28
16781872024-11-07
16880462025-12-28
16973432024-10-30
17070082024-08-24
17186622023-08-23
17282722023-07-23
17380162024-06-17
17481332024-10-27
17579302024-02-18
17678952024-11-14
17778712024-07-19
17883782025-03-29
17981312025-08-01
18080012025-09-19
18179972023-09-02
18270132024-06-28
18374482023-11-29
18471692024-12-10
18584482023-09-14
18683642023-10-11
18785862024-10-12
18885112023-05-18
18978132025-11-12
19086032024-05-15
19180722025-08-22
19288852024-02-29
19376912023-07-06
19479622023-04-25
19576992025-06-14
19687522024-01-18
19780722023-02-22
19872942025-09-30
19979792023-06-01
20077612023-09-18
20172672025-03-05
20275002024-10-09
20388942025-01-27
20471352025-02-20
20588582023-10-12
20687162025-03-11
20780052023-12-28
20888552023-10-14
20981692025-01-01
21074322025-12-01
21189512023-09-19
21273542024-07-28
21375182025-07-23
21484882023-02-09
21580752023-03-04
21680872023-09-18
21787282023-01-05
21889872024-01-01
21989702023-05-26
22072742023-08-01
22175792024-10-24
22277672025-02-17
22383692023-01-06
22475642025-03-08
22589702023-10-03
22671162023-09-14
22780112024-01-04
22879922024-09-04
22988842023-02-09
23088832023-10-25
23178722025-12-01
23280272025-12-25
23380592025-04-06
23472512025-01-17
23571062023-12-10
23682702025-10-12
23779752025-09-08
23870822025-01-23
23974272023-01-15
24075422025-08-20
24179582023-09-28
24272232024-11-26
24376412025-03-03
24482152024-10-04
24584182025-05-30
24687032024-04-29
24774892024-03-30
24887392024-01-18
24986842023-12-24
25079082025-04-17
25170192023-01-16
25289592025-10-06
25370542025-05-23
25471442023-04-01
25587072024-09-08
25689212025-09-21
25774512023-09-01
25883322023-12-04
25972302025-11-23
26084302023-08-12
26174992025-10-09
26274912023-12-20
26387242024-04-17
26473722023-08-24
26577062023-03-27
26672342025-02-16
26771342023-01-17
26886152023-06-06
26975672023-08-26
27072132025-12-22
27173652025-07-01
27283982023-01-23
27386802023-02-05
27488742024-02-01
27588542023-06-28
27689622025-11-12
27771332023-04-19
27873192023-02-09
27971332024-05-16
28073392024-12-12
28180142024-12-03
28283222025-06-09
28382072024-02-22
28482042025-11-13
28580262025-07-16
28675582024-12-12
28782482025-03-27
28877482024-03-14
28985362023-05-26
29074812025-04-15
29188832024-09-23
29283362024-03-23
29376672025-09-15
29476222023-04-26
29586572024-11-14
29670422023-02-19
29774822024-06-08
29888902024-02-08
29976942024-05-16
30083832024-12-21
30185402023-07-24
30278982024-04-20
30389842025-03-31
30478752025-08-13
30580422025-09-16
30672932025-04-18
30775492023-03-05
30887512025-02-21
30983772025-05-08
31071582023-07-21
31175102025-11-03
31286282024-02-25
31373972025-08-09
31470902023-02-12
31581712025-07-25
31676172024-09-30
31774672023-12-25
31882682023-01-14
31972352024-01-17
32074462023-06-29
32171102024-02-09
32278962023-08-04
32386522025-02-10
32475792024-03-01
32577142023-02-10
32688482024-03-14
32775052023-04-07
32873572024-05-16
32976032023-04-29
33078912024-09-01
33174322025-12-10
33282702023-10-13
33376352024-02-07
33488232023-03-01
33584992023-08-17
33676302025-11-12
33774882024-01-17
33884892025-04-05
33972562024-04-25
34074412023-03-11
34171932024-10-29
34271552025-12-27
34377592023-08-10
34488742024-12-13
34580202023-03-21
34676282024-11-04
34772402024-09-12
34885792025-01-17
34985672023-12-20
35080972025-10-06
35172632023-01-03
35284252024-10-22
35378932023-07-27
35483412025-08-16
35582362025-11-26
35682422024-11-21
35783082025-01-08
35883242025-01-23
35985062024-07-16
36074652024-11-04
36170462023-06-27
36276932024-09-09
36373002024-09-12
36478432024-11-05
36579132025-07-12
36672922023-05-14
36770272023-04-25
36872282024-03-10
36986232024-07-01
37074542025-01-04
37180002023-09-16
37272412024-06-22
37388602025-04-03
37482482024-09-07
37578912023-11-13
37687502023-06-22
37786182023-05-26
37873582025-02-20
37981082023-09-01
38074352024-01-13
38175612024-12-21
38282172023-02-21
38379792023-10-13
38484752024-07-21
38580312024-03-04
38674372024-10-25
38779572023-10-23
38872822024-05-19
38986472025-06-20
39080452023-08-17
39176022025-03-09
39271382024-04-08
39380552024-01-15
39485602023-12-24
39575172023-11-19
39670212024-12-26
39782442024-03-27
39887192024-06-20
39982052025-07-12
40080952023-11-30
40182072023-04-22
40282392024-09-16
40380892024-03-07
40470062024-04-06
40585712023-06-27
40678942023-03-19
40778882025-01-30
40886802024-08-19
40977502023-04-27
41076262025-04-19
41176492024-05-15
41283702024-09-18
41389512024-02-13
41487602023-07-06
41584032023-06-30
41674582025-09-06
41781332025-02-04
41878392023-06-24
41989642024-09-04
42088462025-09-15
42173272025-10-01
42278472025-05-28
42385212023-04-14
42470402024-10-15
42576212024-03-20
42672122024-12-07
42789342023-05-20
42870862023-03-31
42971832025-05-25
43085792025-02-26
43174952025-07-20
43288072023-07-31
43382642025-02-08
43484272023-08-29
43570972023-12-13
43684102025-06-25
43774532023-10-13
43886592025-07-29
43985182025-09-30
44077352023-07-30
44174122025-06-13
44282412025-09-14
44375462023-02-10
44482902023-08-21
44575072024-06-01
44678762025-02-01
44771262024-03-03
44881422024-02-05
44974792024-06-13
45083772025-03-27
45189902024-12-02
45276402024-08-14
45386242025-07-19
45488542025-03-21
45581952024-02-08
45675512023-01-10
45788392023-04-24
45875672023-09-24
45975532023-03-15
46079922025-02-02
46187362023-09-18
46271672025-10-07
46385722024-07-29
46474732025-10-26
46571982023-02-11
46682572023-05-10
46785312025-03-21
46881612025-12-03
46971012024-11-20
47076032024-09-16
47175502024-04-03
47285932025-04-14
47383042024-05-24
47489152025-02-24
47576662025-02-15
47680492023-03-11
47782572025-04-20
47873362024-05-19
47981952025-09-28
48070102025-11-27
48187042025-02-04
48281232024-08-17
48382402025-08-13
48488902025-07-19
48583792023-09-06
48675752023-02-13
48784172025-07-04
48884582024-08-03
48981872025-02-25
49077432023-04-23
49186182025-05-19
49276592025-08-23
49379552025-06-10
49483322024-05-05
49571902023-04-06
49687242025-11-20
49782732025-01-31
49875612023-10-25
49985172025-05-31
50086492023-02-26
50182172023-03-08
Sheet1
Cell Formulas
RangeFormula
A2:B501A2=LET(rNo,RANDARRAY(500,1,7000,9000,TRUE),rDt,TEXT(RANDARRAY(500,1,44927,46019,TRUE),"yyyy-mm-dd"),HSTACK(rNo,rDt))
Dynamic array formulas.
Click to expand...
Thanks alot!!
 
Upvote 0
purna said:
Thanks alot!!
Click to expand...
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
VBA/ Excel Query on Random Numbers and dates
Replies
1
Views
938
Peter_SSs
Peter_SSs
Red over White
  • Solved
Identifying row numbers where the date is the same
Replies
5
Views
294
Fluff
Fluff
N
  • Question
Creating a Random Number Generator
Replies
4
Views
2K
Fluff
Fluff
O
  • Solved
Trouble finding vba code to create random generated number upon opening
Replies
8
Views
703
Ohyaisee
O
D
  • Question
Macro to duplicate a name that has been randomly generated IF cell value has a number
Replies
2
Views
573
dallekvist
D

Forum statistics

Threads
1,215,734
Messages
6,126,542
Members
449,316
Latest member
sravya

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top