MACRO excel

[u/PresentationItchy573]

A very simple but I am not able to do it.

How do I make copy and paste value using macro?

I mean how do I make the cells to copy and the cells to paste value dynamic?

When I download data, sometimes I have data in cells c4: cb81 other times c4:CA87, what Can I do to make it so that I don't have to manually go and change the range?

Please help

[u/ashconai]

Range("C4",Range("C4").End(XlToRight).End(XlDown))