very simple VBA question for Excel

  • Thread starter Thread starter Giose
  • Start date Start date
G

Giose

Hi,

I hope that someone can help with this very basic question.
I need to concatenate information in a well define cell, based on the
position of the active cell.
Let's suppose the cell where the result must come in is H5, the active
cell is B8, and I need to concatenate in H5 the value of the first
cell in the row of the active cell (A8) with the value of the active
cell (B8) separated by an underscore.
So the result of the formula would become H5=A8&"_"&B8
I hope it is understandible.
Thanks for the help
 
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

SUMIF with criteria "<>" & "=" 4
Change Event (How post Date/Time to Changed Cells Rows but different Column) 7
Is there an Excel Function that can be used in lieu of this formul 5
Variable in Range for excel 2
Creating Charts using VBA 0
Named Range maker code 9
Simple question 1
VBA code to fill rest of cell with dashes (-) 2

Back
Top