Finding next empty column

[Engineers08]

I need to append this macro to find the next empty column to place the data in. The orignal VBA works fine, but I need to go into the editor, and repalce the offset number every time I add a new row (weekly).

Here's the orignal coding:

Please Login or Register  to view this content.

I tried this, but it's not working as i would have hoped.

Please Login or Register  to view this content.

Any grand ideas you gurus?

`engineers08

[Shijesh Kumar]

Hi,

Can you upload a sample sheet..clearly stating what you would like the macros to do..

[Engineers08]

Sure.

Here's an example. I need to take the data from the "New Data" sheet, then find which values are missing, and fill them with 0's. It then needs to copy this data over to the "Report" sheet, and place it in the next open column.

The code works fine for everything but finding the next empty column to paste it. I currently change the offset value everytime.


`engineers08

[royUK]

Why would adding a row affect the Column offset?

Is this what you want

Please Login or Register  to view this content.

[Engineers08]

This script gives me a runtime error at this point.

Please Login or Register  to view this content.

Any idea why?

[royUK]

Can you attach the workbook?

[Engineers08]

Yup, can do.

[royUK]

Try this instead

Please Login or Register  to view this content.

[Engineers08]

The code to find the next column and fill it works great, but the now my coding for finding the un-included values and filling them with zero's is not working. The code here returns

34
2143
552
3
0
0
0

What I needed, and used to obtain, was
34
2143
552
3
0
2354
0
32


Any idea why the mechanics of the macro changed? I have added the macro, and uploaded the workbook again.


`Ryan

[royUK]

Try this

Please Login or Register  to view this content.