VBA Amendment to select found cell and input data

[Spoonman667]

Hi,

I've found this bit of VBA that almost does what I need it to in that it successfully finds the next available column (from left to right) even when it's embedded in other data.

Currently, when it finds the column, it comes up with a message box stating the columns number however what I require is for it to find the column and then add data in row 2 of that column. Also Ideally I would like it to ignore row one as I have headers....

I've tried a few different things to amend this myself but it's not going well so thought I'd open it up. Any help would be very much appreciated.

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[Spoonman667]

Thanks Fluff!

Nearly there... Ideally I could do with it finding the next available column after the header though, any idea how I'd do this?

[Fluff13]

Do you have headers in row 1?

[Spoonman667]

Yes, sorry, should've specified

[Fluff13]

In that case maybe

Please Login or Register  to view this content.