Vba macro to list un colored data remaining but instead of the number that is uncolored it would list the position it is on.

Estatefinds

Board Regular
Joined
Sep 14, 2015
Messages
169
So for the following data: The individual numbers are in columns BB Through BF.
so I need a macro to list the remaining uncolored numbers data but instead of the number itself listed it would be the position in which it sits. so the first example will show the numbers and the second example will show the positions. and place the list in column AN on the same row its starts reading data at from top to bottom. Please! Thank you
38131426
38132728
124272830
510122433
414151731
211181922
717182628
515193234
69162634
914223033
1018243135
418192731
24202433
2025272932
417252630
1315182035
37132633
1021242834
1218252834
315252729
2892131
1012173033
28131732
38182533
2483334
25162123
45222324
322252633
711161928
213183133
36101823
813162133
912232735
623252730
46272832
1220222730
917212235
1381632
3492728
1516242527
522263032
47101620
310162032
410252735
617192829
611121625
1392528
611162225
17141722
1522243132
35172329
1516232528
1892124
1421223233
714172529
614223033
1020232833
69101627
19202730
12101820
819232933
918192933
1518192226
618202735
813232834
515233435
613242829
17273035
1571831
912161835

<tbody>
</tbody>


second example:
A1B1C1D1E1
A2B2C2D2E2
A3B3C3D3E3
A4B4C4D4E4
A5B5C5D5E5
A6B6C6D6E6
A7B7C7D7E7
A8B8C8D8E8
A9B9C9D9E9
A10B10C10D10E10
A11B11C11D11E11
A12B12C12D12E12
A13B13C13D13E13
A14B14C14D14E14
A15B15C15D15E15
A16B16C16D16E16
A17B17C17D17E17
A18B18C18D18E18
A19B19C19D19E19
A20B20C20D20E20
A21B21C21D21E21
A22B22C22D22E22
A23B23C23D23E23
A24B24C24D24E24
A25B25C25D25E25
A26B26C26D26E26
A27B27C27D27E27
A28B28C28D28E28
A29B29C29D29E29
A30B30C30D30E30
A31B31C31D31E31
A32B32C32D32E32
A33B33C33D33E33
A34B34C34D34E34
A35B35C35D35E35
A36B36C36D36E36
A37B37C37D37E37
A38B38C38D38E38
A39B39C39D39E39
A40B40C40D40E40
A41B41C41D41E41
A42B42C42D42E42
A43B43C43D43E43
A44B44C44D44E44
A45B45C45D45E45
A46B46C46D46E46
A47B47C47D47E47
A48B48C48D48E48
A49B49C49D49E49
A50B50C50D50E50
A51B51C51D51E51
A52B52C52D52E52
A53B53C53D53E53
A54B54C54D54E54
A55B55C55D55E55
A56B56C56D56E56
A57B57C57D57E57
A58B58C58D58E58
A59B59C59D59E59
A60B60C60D60E60
A61B61C61D61E61
A62B62C62D62E62
A63B63C63D63E63
A64B64C64D64E64
A65B65C65D65E65
A66B66C66D66E66
A67B67C67D67E67
A68B68C68D68E68
A69B69C69D69E69
A70B70C70D70E70

<tbody>
</tbody>
 
Last edited:
ok never mind i just figured out what these were this is not for the program i thought it was.
ill let you know when i find it thank you!!!

so im trying to figure out where to find out where the program is for this i looked in developer but cant find it. let me get a screen shot. be right back.
 
Last edited:
Upvote 0

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,215,007
Messages
6,122,670
Members
449,091
Latest member
peppernaut

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