Find specific cell, then dim its value as string

[ks100]

Need to:

1. Find column with header title "quantity" (i.e. text in first row for that column is "quantity")
2. Dim the contents of the third row of that column as a string

[Solus Rankin]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Perhaps:

Please Login or Register  to view this content.

[ks100]

Perhaps:

Please Login or Register  to view this content.

Perfect, thank you

[berlan]

With find function:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[berlan]

@JOHN H. DAVIS, you are the expert, but to minimize the interaction between VBA and Excel, generally I would not use activecell or select. Is there a specific reason for this?

[JOHN H. DAVIS]

@JOHN H. DAVIS, you are the expert, but to minimize the interaction between VBA and Excel, generally I would not use activecell or select. Is there a specific reason for this?

Not really. Your code is more efficient and performs the same tasks in this circumstance. However, I find that activecell has it's place in coding and I tend to rely on it probably a bit more than I should.

[berlan]

Not really. Your code is more efficient and performs the same tasks in this circumstance. However, I find that activecell has it's place in coding and I tend to rely on it probably a bit more than I should.

Okay, I see, thanks for your reply

All best