Generic code for selecting the next column from a specific range - VBA

[KNKN9]

Hi,

I have a data set similar to below

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]y[/TD]
[TD]y[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to find a code that allows me to selecting the next empty column. This can't use the Range("C12") as every week data gets updated and a new column will be filled with data.

Hope someone can help.

Thanks
Naomie

 

[steve the fish]

You could try:

lr = Range("C" & Rows.Count).End(xlUp).Row

then use the variable like this:

Set rng = Range("C" & lr)

as an example.

 

[Jonmo1]

That finds the next empty 'ROW'
We want the next empty 'Column'

Try

lc = Cells(12, Columns.Count).End(xlToLeft).Column + 1

Then you can use it like
Cells(12,lc)

 

[steve the fish]

I really do need to start learning to read.

 

[KNKN9]

Thank you very much Jon,
This code works exactly how I want it to.
Much appreciated

Naomie.

 

[Jonmo1]

You're welcome.