VBA Format Data using R1C1

[kenadams378]

I have the following code that takes a set of file data and picks out the relevant data and discards the rest.

For October (attached) it worked perfectly fine but with November data (attached) if you run the macro it leaves the 1st column blank which should be populated by the fund code.

Can anyone advise why the 1st column is being missed even though the data is in the same format and there have been no changes to the code.

Please Login or Register  to view this content.

Many thanks

[Bob Phillips]

The two files are very different so I don't know why you expect them to behave in the same way.Anyway, Oct stays blank for me too.

[kenadams378]

The data is different but the fundamental criteria is the same. The oct file is the completed macro version once the macro has been run and what Nov should look like.

Data in R1C1 is same and the data in R5C2 is the same, just different values.

The code should still return correctly as per Oct file.

[Bob Phillips]

It's no good showing us the after file for one month and the before file for the other if you are expecting us to explain why the code behaves differently for those two months.

[kenadams378]

Apologies, attached is the orignal file for Oct too.