Do Loop with variable output

[tubbsy]

Hi,

I have written the code below to basically populate column C within a sheet called Source. It takes the contents of the column BH in the same sheet and appends a hypen and a number corresponding to the row.
For example: AO145-090909-1 where AO145-090909 is the contents of C, the - is appended and 1 is the row that it is present within.

The problem that I am having is around:

ActiveCell.FormulaR1C1 = "=(RC[-42]&""-""&RowCount)"

By adding the variable RowCount into this part of the code it fails. But I need to add the row count into the cell.

Please Login or Register  to view this content.

Thanks for any help, its greatly receieved.

tubbsy

[royUK]

This will be a lot faster

Please Login or Register  to view this content.

[tubbsy]

Thats great. Thanks royUK.

Is it possible to adapt this code to reference mulitiple sheets?

For instance, if I wanted to populate the cell A1 with concataneted data from two separate cells in two separate sheets. I had written the following code to do this:

Please Login or Register  to view this content.

Thanks again