LinkBack URL
About LinkBacks
Hi
I need to add values to my data validation list , and added value should appear at top of the list ,please help me on this
Hi
I need to add values to my data validation list , and added value should appear at top of the list ,please help me on this
Create a named range, that is dynamic, then you need to grab the range and shift it down a cell, and then put the new value at the top, range("range").offset(-1,0).value = new value
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks