Finding a value in a sheet can be very handy when using Excel VBA, within macros or sheet code. Luckily, VBA has a Find function that you can call on a Range, which can find values in the sheet. It also allows you to configure how the function will search for whatever you’re looking for.Continue reading “How To Use Excel VBA Find, With Example!”
Tag Archives: Excel
The Right Way To Do Last Modified Date In Excel (Without Using TODAY)
Excel still holds an important place in a lot of the business software world. Underneath its simple spreadsheet is a powerful tool with its own robust coding language (Visual Basic) and frameworks. I recently ran into an interesting problem when I was working on an Excel project: How do I store the last modified dateContinue reading “The Right Way To Do Last Modified Date In Excel (Without Using TODAY)”