Last value and quotes

Excel Help for Last Value And Quotes in Automating Data Analysis Tasks

Forum Topic

Last Value And Quotes

Rate this:

(3/5 from 1 vote)

The first issue maybe due to the final iteration of the loop return the empty cell at the end of the range selected. This could be caught like:

VBA Code:

If nxtval <> "" Then
'do whatwever
End if

The second issue could be due to the double quotes around the nxtval. Have you tried to remove them?

Excel Business Forums Administrator

Posted by Excel Helper on 28 Sep 2007

View Full Post

Find relevant Excel templates and add-ins for Last value and quotes in the Excel Business Solutions Directory