I'm using a macro and with this i copy a value to a column...
but it starts from row2 and row1 is empty, why?'valueShare.Copy
'Worksheets("Sheet2").range(colSheet2).End(xlUp).Offset(1, 0).PasteSpecial xlValues