Home |
Search |
Today's Posts |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well I have just tried the sample data and it worked fine.
It might be copying the data from the web that is a problem. Try this data with Dave's original macro. Bh72 R.sol A.tum EbN1 N.euro G.metali PF00013 PF00013 PF00013 PF00013 PF00013 PF00013 PF00015 PF00015 PF00015 PF00015 PF00015 PF00014 PF00023 PF00023 PF00023 PF00023 PF00016 PF00015 PF00027 PF00027 PF00024 PF00027 PF00023 PF00023 PF00028 PF00032 PF00027 PF00032 PF00027 PF00027 PF00032 PF00033 PF00032 PF00033 PF00032 PF00032 PF00033 PF00034 PF00033 PF00034 PF00033 PF00033 PF00034 PF00035 PF00034 PF00035 PF00034 PF00034 PF00035 PF00036 PF00035 PF00036 PF00035 PF00035 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) wrote in message oups.com... I'm using the sample data. After running the macro the results are as follows: Bh72 R.sol A.tum EbN1 N.euro G.metali PF00013 PF00013 PF00013 PF00013 PF00013 PF00013 PF00015 PF00015 PF00015 PF00015 PF00015 PF00014 PF00023 PF00023 PF00023 PF00023 PF00016 PF00015 PF00027 PF00027 PF00024 PF00027 PF00023 PF00023 PF00028 PF00032 PF00027 PF00032 PF00027 PF00027 PF00032 PF00033 PF00032 PF00033 PF00032 PF00032 PF00033 PF00034 PF00033 PF00034 PF00033 PF00033 PF00034 PF00035 PF00034 PF00035 PF00034 PF00034 PF00035 PF00036 PF00035 PF00036 PF00035 PF00035 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |