LinkBack URL
About LinkBacks
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
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
Last edited by ks100; 01-02-2014 at 03:57 PM.
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Perhaps:
Please Login or Register to view this content.
Perfect, thank youOriginally Posted by JOHN H. DAVIS
With find function:
Please Login or Register to view this content.
You're welcome. Glad to help out and thanks for the feedback.
@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.@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?
Okay, I see, thanks for your reply
All best
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks