very simple VBA question for Excel
 

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

very simple VBA question for Excel
 

Hi Giose -

Range("H5") = Cells(ActiveCell.Row, 1) & "_" & ActiveCell

--
Jay


"Giose" wrote:

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