Choosing a value in a row

L

Linda Kneller

Hi,

I am trying to use Excel 97 to pick a value in a row of a
spreadsheet. I have basically imported data and from each
row I want to keep the last value. The last value will
not always be the same or in the same column. Is there a
way to do this? I would like to set this up as a macro.
Any ideas?

Thank you
 
J

jr

the key here would be to use the " CTRL-right arrow " key
combination in your macro. This will always get you to
the rightmost value in a row of data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Drop down list control value in vba 2
Cell data entering slow! 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Adding a big matrix in Word 2013 5
Creating a Chart on form from selected data in query. 0

Top