Forum Discussion
Editing Macros
I had someone create the Macro below and now the source doc has 3 additional columns and I can't figure out how to edit it to account for them. It simply takes a list of products, in the first sheet ...
Hi,
According to the line below, I think that the code already takes any new column into account, as it's going through each column in the current region, not to a fixed number of columns.
For m = 1 To .Range("A1").CurrentRegion.Columns.Count
Could you provide a sample of the data that you work on, to apply the code on it and figure out the issue?
Haytham Amairah Thanks, I assumed it had to do with the added columns but it looks like the issue was a blank column header. Appreciate your reply
