.copy not working

[cknnugget]

Running a macro that copies a cell to the clip board so the user can ctrl+V the contents into a program online. ctrl+V works to paste into a word or excel file, but when attempted in the online program it does not work. Is there a work around.
Here is the current code

Sheets("Emergent Response").Range("AN3").Copy

 

[ExcelToDAX]

If you turn on your clipboard, "Windows button + V" instead of Ctrl+V, you can see the previous things that have been copied in your clipboard. When attempting this code, I do see this in my clipboard and can paste it to a website. Can you try this and see if it is in your clipboard?

 

[cknnugget]

It does not show in the clip board

 

[cknnugget]

If you turn on your clipboard, "Windows button + V" instead of Ctrl+V, you can see the previous things that have been copied in your clipboard. When attempting this code, I do see this in my clipboard and can paste it to a website. Can you try this and see if it is in your clipboard?

I believe I found the issue. The cell that was being copied was hidden. After unhiding the cell it copied to the clip board. The work around was I made a cell that was visible = the hidden cell and changed the text to be the same color as the background in a protected area of the sheet. Crude, but copy now works.