Macro not working

[Jyggalag]

Hi all,

I have this macro that i recorded, and it produced this code:

However, when I use it, it just erases everything in column E and does not paste the data from column F at all!

please help me fix it`??

this is my setup, with the macro being called "update", as you can see, my cells are all blank in column E

 

[Fluff]

Do you get any error messages?
Also do you have any merged cells?
And is the sheet protected?

 

[Jyggalag]

Do you get any error messages?
Also do you have any merged cells?
And is the sheet protected?

Hi Fluff,

Thank you!

No error messages.

I do have a filter that I often put on however for the columns, so it "hides" row 2-350, but it should still work, no?

the sheet is not protected

and I do not have any merged cells in the two columns

 

[Jyggalag]

U

Do you get any error messages?
Also do you have any merged cells?
And is the sheet protected?

UPDATE:
When I use the macro without having a filter on it works.

However, when I filter so rows 2-350 are hidden, it (for some unknown reason) just removes all the text in column E?

Any idea why?

 

[Fluff]

Do you have any event code on that sheet?

 

[Jyggalag]

Do you have any event code on that sheet?

What is an event code?

The only code I have so far is from the macro in the initial photo I attached

 

[Fluff]

In that case I have no idea why that is happening.

 

[Fluff]

Change of plan, you are just copying the visible cells, rather than the entire column. You will need to remove the filter.

 

[Jyggalag]

Change of plan, you are just copying the visible cells, rather than the entire column. You will need to remove the filter.

Hi Fluff,

Is it possible to do it, while the filter is still there? Or no?

I tried removing the filter, creating the macro again (it works) and then putting on a filter, filtering so rows 2-400 are hidden, and then using the macro again.

However, this results in the columns values all going blank due to the filter apparently

very silly, you cannot work around this in any way?

 

[Fluff]

When you have hidden rows the copy will only copy the visible cells, but will paste those values in the other column starting in E1 regardless of whether the row is hidden or not.