Excel VBA-fixing cells

Y

Yasmine

Hello,

I am using a VBA macro to copy and paste different sets of data on the
same excel sheet.
How can i make sure than I don't paste over already non-empty cells?

Can someone help me with this ?

Thanks!
Yasmine
 
K

Kevin Stecyk

Yasmine,

Usually it is best to show some code so that people can provide more
specific advice.
How can i make sure than I don't paste over already non-empty cells?<
Click to expand...

You can test the cells you are pasting to prior to the paste to see if they
contain data.

That seems like a "smart answer" but is not intended to be. If you code was
visible, someone could provide more specific advice.

Best regards,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel, assign cells in multiple worksheets from one sheet 1
using the =page! feature to transpose a row to column 0
Excel Send Lotus Notes Mails With VBA Macro Excel 0
Copy/Paste and remove blanks VBA 0
VBA set thick borders around non empty cells in range 0
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3

Top