Add data to dynamic range

[gaudrco]

I have a dynamic range that expands when I add new data(naturally). I would like to add code to a button that I have that will adddata to the range when the button is pressed. This is the line of code I amworking with:

[FONT="Calibri"]Sheets("Competitor OverviewData").Range("CompetitorsLOV").Offset(1, 0).Value =Range("C2").Value[/FONT]

My expectation for the code is that when the button ispressed, the text from cell “C2” will be added to the bottom of my dynamicrange called “CompetitorsLOV” which is located on sheet Competitor OverviewData.

Thanks!

 

[Akuini]

Try this:

With Sheets("CompetitorsLOV").Range("CompetitorsLOV")
.Offset(.Rows.Count).Resize(1) = Range("C2").Value
End With

 

[gaudrco]

Thank you that worked. I had to fix the sheet name because you had it the same as the range name but other than that, perfect

 

[Akuini]

Ah, sorry for the wrong sheet name.
You're welcome, I'm glad to help, & thank you for the feedback.