Populate cells in specific columns of active row

[alyssa75]

Hi All -

I am trying to populate a predefined variable into a specific column of the active row (this is part of a looping code).

Here's what I am trying to do:

With ThisWorkbook
.Sheets("Temp").Cells(Rows.Count, "A").End(xlUp)(2, 1).PasteSpecial xlPasteValues
.Activate
.Range(ActiveRow, "EH").Value = MyRegion
.Range(ActiveRow, "EI").Value = myDept
End With


Any ideas are much appreciated. Thanks!

 

[Joe4]

For one thing, you are using "Cells" syntax with "Range".
This:

Range(ActiveRow, "EH")

should be written like this:

Cells(ActiveRow, "EH")

or

Range("EH" & ActiveRow)

Also, is "ActiveRow" a variable you have defined somewhere? If not, I don't think it will work. If you want the active row, you need this:

ActiveCell.Row

There may be other problems with your code. I cannot tell if you are trying to apply this to a single row, or a whole range.

 

[alyssa75]

Thank you. I was able to use your tips to modify the code and it is now doing exactly as it should! Thanks much!