Concatenate VBA syntax

A

Apostel

Joined
Apr 15, 2011
Messages
1
Reaction score
0
Hello all,

I hope you can assist me with a dilemma I'm having.

I have 2 cells I need to concatenate into my summary sheet. This is the code I'm trying to make work. If I omit '!BX8 I can get '!BX7 to populate, but once I add the reference for BX8 I get errors. Any thoughts?

Code: 
Dim LastSheet As String
    LastSheet = Worksheets(Worksheets.Count).Name
    With Worksheets("Summary")
    lMaxRows = .Cells(.Rows.Count, "H").End(xlUp).Row
    .Range("H" & lMaxRows + 1).Formula = "='" & LastSheet & "'!BX7 & '!BX8"
 

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

Hidden sheet bleeds through 3
Generate Subtotal Summary from Sheet1 into Sheet2 16
My Never ending ARRAY code problems 18
Copy Tab Names from Several Sheets and Copy Last Row from Same She 7
Multiple Countif - i,j,l counters probably mixed up 6
Loop to copy paste rows base on table arrays 0
Help! Question about Worksheets.Copy 1
Excel Count If Formula Question 1

Top