Select entire Column of data even when there are blanks in some rows, xlDown

Hi guys,

I am trying to find a valid code that would be able to select all data in a the Column "26" on my Daily Input Sheet. [first paragraph of code] I tried using the code below, it works but it stops where there are breaks in the data. For example the raw data goes until row ~1500 but along the way there could be some rows that are blank, so Excel simply selects until say row 130 where the first blank is... Does anyone know how I can get around this problem and have VBA keep going until the last identifiable piece of data in that row ~1500, and select all of it including the blanks, where I would then paste it on the [2nd paragraph of code].

Please Login or Register  to view this content.

Thank you kindly, appreciate any help on this

You could change it to

Please Login or Register  to view this content.

Or even better, something like this. It's always a good idea to avoid .activate and .select syntax wherever possible.

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Thank you so much for you're help, this is a way to do it ansolved the Thread

Glad we could help & thanks for the feedback