excel vba - VBA: copy whole column content starting for a specific and and the data below it -

the thing want copy column want copy data on specific cell , data below it.

let example, want copy cell c5 , below, disregard c1 c4. possible?

further comments below question, here 1 way. work in scenarios. whether have blank cells or not...

option explicit  sub copycells()     dim ws worksheet     dim rng range     dim srow long, lrow long      '~~> change relevant worksheet     set ws = thisworkbook.sheets("sheet1")      srow = 5 '<~~ starting row      ws         '~~> find last row in col c         lrow = .range("c" & .rows.count).end(xlup).row          '~~> if last row < start row         if lrow < srow             msgbox "start row cannot greater last row"         else             '~~> create range             set rng = .range("c" & srow & ":c" & lrow)              '~~> copy             rng.copy              '             ' want copied data             '         end if     end end sub