Home > Forum Home > Automating Data Analysis Tasks > Looping Query using value from next cell > Last value and quotes Share

Last value and quotes

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


Forum TopicLogin

Last Value And Quotes

Rate this:
(3/5 from 1 vote)
SurprisedThe 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 on
 
View Full Post

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