last cell as label caption

  • Thread starter Thread starter pswanie
  • Start date Start date
P

pswanie

one more Q. how will i go to the last cell in column b and make that the
caption for label1?
 
because of new limits in Excel 2007 (1 Mega rows) I recommend to do it this
way:
Label1.Caption = Cells(Cells.Rows.Count, 2).End(xlUp).Value

Vlado
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple labels on userform 2 update 2
Set Userform label text if form is not loaded??? 3
Labels and Captions 2
Stepping through v. running code 1
Change label name with loop 5
cell values as label captions 1
label.refresh error 1
Changing the text of a label on a Userform 1

Back
Top