Copy Cells to Clipboard if Contain Data

[ChristovJN]

Good Afternoon All

So I'm very new to VBA but scripting macros is part of my new job role and I'm learning as I work - therefore I'm having to frankenstein a lot of my code together as I go and reevaluate it later on as I'm reviewing my work.

The requirements for one project is to put together a file that can be uploaded to a website that will automate payments. I've coded the entire thing and I'm really happy with the outcome, I had to butcher a code into it to export to .txt file but I understood it as I was going through it so I'm happy.

The problem is, previously I was able to use the following to copy Cell U6 down to the last used cell in Column U to the clipboard:

Please Login or Register  to view this content.

It worked perfectly until I got right to the end and had to cell map based on the data I was given, now I've had to put a IF statement into the cells in the U column and the VBA code is now picking up all the empty cells (even though it was "" in the FALSE section of the IF statement). There are 50 cells in the template but ideally I'd like this to run all the way down as far as required, but filling out those cells will pick them up in the end .txt file.

Could someone talk me through any way of changing this code so that it only grabs cells in that column that actually have data in them?

Thanks in advance!

Many thanks in advance.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[ChristovJN]

dangelor,

Thanks for the reply, unfortunately this retrieves the same results as the original code.

[dangelor]

Could you post your existing code?

[jeffreybrown]

Hi ChristovJN,

Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.