Excel - VBA: Need support to lynch the Max function

Asked

Viewed 181 times

0

How can I reference a certain column sheet through the command below in VBA?

Application.WorksheetFunction.Max
excel vba

1 answer

1

Just reference the Range that you need.

Example:

Application.WorksheetFunction.Max(Worksheets("Plan1").Range("A1:A10"))

  • Grateful for the return.

  • I’m creating a client record. In a Textbox that I created in my userform, I want its values to have an order of growth starting at 1, then 2 and so on. So, I created the following code: Textbox2 = Application.WorksheetFunction.Max(sheet2.Columns(1)) + 1. When I try to execute the code it fails in this line

  • Hi @Lázarogouveia, I think the ideal would be to create another question for this, because the purpose of stackoverflow is that questions that may be common among other people, be answered here and stay as a great source of solutions.

  • grateful for the support? I am new in VBA and would love to master the language. Is there any way to keep contact otherwise, beyond here?

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.