Choosing a value in a row

  • Thread starter Thread starter Linda Kneller
  • Start date Start date
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
 
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.
 
Back
Top