Populated columns in row

[GoPens]

I'm using Excel 2010. Interested in obtaining which columns in a row are populated with information and then storing it to a variable. How would I go about getting this?

TIA,

Tim

 

[SkipVought]

Hi,

That is a very general question.

Could you please be more specific?

Do you currently have any code that you have tried to use? If so please post and explain where you're having a problem.

DETAILS please.

 

[Andrzejek]

Does your data look something like this:

[pre]
A B C D E
1 MyColA MyColB MyColC MyColD MyColE
2 abc 123 xyz
3 765 ju6 yy 87
4 bbb yt5 7u
5 jjj 66[/pre]

If so, what do you mean by: "storing it [information] to a variable"?
Which data goes to what variable?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

As you can see, we are GUESSING at what you mean.