Problems with loop and cells merged

[sylvain133]

hey !!

I have a problem. I need to copy in following cells, values. But the difficulty is that some cells are merged and some other not.

So when I use a loop like :

For i = 1 to n

Cells(i, 1).select
Selection.Paste

Next for

I paste twice the values in merged cells. What can I do to go directly to the next cells even if it's merged ?

Thanks in advance for your help!!

Sylvain

[arlu1201]

Can you explain with the help of a sample file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[sylvain133]

azer.xlsx

I need to paste values (from an out worksheet) in the column page 2. And you will figured I had to merged some cells to have the same
size everywhere so the problem.

What kind of loop could I use to avoide the merged cells problem.

Thanks you !!!