PDA

View Full Version : need vba help in excel



serbsta
11-08-2008, 09:14 PM
I need to make a vba code that will move digits in cells and reverse their order, heres what i need.

Ive got 5 digits: 9, 7, 10, 12, 5 displayed from cells B1 to B5
I need to get these digits moved to cells D1 to D5 but in reverse order!

Please help.

Demosthine
11-08-2008, 09:44 PM
Good Evening.

First and foremost, welcome to the Forum. It's always good to have new members.

Second, this would appear to be a homework question, so I'd like to refer you to the Board's Homework Policy (http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hom_faq_item):



Homework
Please don't ask us questions directly out of your coursework materials. We are happy to provide direction and guidance for those studying VBA and other software. Be open about the fact that it is coursework, and you'll likely find yourself with more resources than you could possible need.


That being said, you will want to use the Worksheet.Cells Object and a For ... Loop to cycle backwards through the cells.

I hope this gets you started.
Scott