• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

VBA: Help with setting multiple cell range


In Excel VBA:  How would I write the syntax for the following:

 Set UserNameSubmissions = Sheets("Event Management").Range("B1") & " - " & Sheets("Event Management").Range("H95")

Open in new window

I am want the output to look like:
John Doe - 85.34%  

The issue is that it wont take the & " - " &.

Maliki Hassani
Maliki Hassani
1 Solution
The issue is the 'Set' try:

UserNameSubmissions = Sheets("Event Management").Range("B1") & " - " & Format(Sheets("Event Management").Range("H95"),"0.00%")

Open in new window

Then to put it back into the sheet or work with it...
Sheets("Event Management").Range("xxx")  = UserNameSubmissions 'put range address in xxx

Open in new window

Maliki HassaniAuthor Commented:
Excellent Thanks!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now