We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub FindLastNonZero() Dim leftmost As Range Dim str As String str = "MAX(COLUMN(4:4)*(4:4<>0))" Set leftmost = Cells(4, Evaluate(str)) leftmost.Select Exit Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Macro to convert table into pivot tables||25||66|
|autofill formulas using macro||8||47|
|Excel - Active X Checkboxes Groups||45||32|
|Additional Controls in Excel VBA Does Not Show Anything||5||21|
Join the community of 500,000 technology professionals and ask your questions.