Respected Experts, Range Chart.xlsx
Kindly help me in creating macro for below problem.
I want to convert column values given in number to a particular range. I have shown that range chart in my excel attachment.
Example value in column -
15 convert to 1-500
318 convert to 1-500
580 convert to 500-1000
5875 convert to 5000-10000
780 convert to 500-1000
Thanks,
Harman
Hello Harman. Try the following macro:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
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.
Thankyou Alpha...Mumps.....Code is working for my problem......Thankyou very much
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks