| Home > Forum Home > Automating Data Analysis Tasks > Looping Query using value from next cell > Last value and quotes | Share |
| Forum Topic | Login |
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:
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 | |||
| View Full Post |
| Find relevant Excel templates and add-ins for Last value and quotes in the Excel Business Solutions Directory |