Member Avatar for devinem

How can you write a macros that will loop until it finds a blank cell. Then, once the first blank cell is found do a vlookup to a set of data? It will be looping on the same row.

Edited by devinem
  • 2 Contributors
  • 1 Reply
  • 119 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Taywin
Member Avatar for Taywin

Not sure what you mean by your question... If it is OpenOffice, you should take a look at VLOOKUP(). The first value would be an empty string, and the first column in table array must be the column you are looking for. i.e. VLOOKUP("", A2:C7, 2, TRUE).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.