I want to locate a cell. We can use cells(1, "i"). "I" column means the "type" which is the head(first cell content) of the column. Is there a way to use the name "type" instead of "I"? For the reason that the column of I may change, For example after some modification the I column may change to save the name of the company not type.I want the vba script to be more flexible. Can it be made?
Hi,
This is really a question that belongs in the VBA forum as it is not a simple Excel function like Sum() or Count() or VLookup().
When you ask a question that is about VBA you need to ask the question from the VBA Forum.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I have moved the thread to the correct section. Please ensure that threads are started in the appropriate sub-forum in future. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Say column heading in row 1 then you can use :
Please Login or Register to view this content.
Last edited by sanram; 04-18-2017 at 02:34 AM. Reason: Code corrected
@ sanram
I'd use Application instead of Worksheetfunction beause WorkSheetfunction wil go into Debug when no match is found. Application 'stores' the error and can be picked up by using IsError-function.
Also shouldn't it be Rows(1) ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes. It was a typo. I have corrected this already. Thanks.Originally Posted by bakerman2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks