Selecting the first non-blank cell in a column

[zakynthos]

How would you write the VBA to:

1. find the first non-blank cell in a column (say Column A),
2. select it and
3. select all other not blank cells in columns to the right of A, say columns B to M?

Many thanks.

 

[Peter_SSs]

It would be good to know what you intend to do with those cells once selected. In vba it is rarely required to actually select cells to work with them. In addition, selecting slows your code considerabley.

I also have some other questions:

1. Is it known if the first non-blank cell in column A is a constant? or a formula? or unknown?

2. Is it known if the non-blank cells in columns B:M of the row in question will all be constants/formulas/unknown?

 

[zakynthos]

Many thanks for your reply.

The values in cells in Column A are 9 digit numbers.

Once 'selected' (or 'found' if you prefer), I want to copy the column of non- blank cells (they are ) and the linked rows of these cells in columns to the right

The non-blank cells in columns B:M of the row in question are all formulas, (mostly Vlookups and some conditional formulas) that link to another tab.

I will then want to paste the range found (example A200:M9000) to another tab,(called 'Inclusion list')

 

[Peter_SSs]

Sorry, I'm afraid that I'm not really able to grasp just what you have or what you are trying to do.

 

[zakynthos]

Thanks for your help - since I posted the question, I've thought of a simpler solution - but I really appreciate your suggestions because I can adapt the code for another part of the program I'm compiling