Application screenupdating false not working excel 2016 dating late bloomer
Cells(j, 35) = "" Then Go To 100 myconcat = myconcat & ws. Cells(1, 35) = myconcat myconcat = "" For j = 6 To 1000 If ws.
Most people like me and you are not real Microsoft Office gurus.
Paste Special Paste:=xl Paste Formulas, Operation:=xl None, _ Skip Blanks:=False, Transpose:=False Application.
Many people write their own macros to manipulate the information in a workbook.
Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.
Range( _ "AK6: AK" & lrow), Sort On:=xl Sort On Values, Order:=xl Ascending, Data Option:= _ xl Sort Normal With ws.
Cells(j, 38) = "" Then Go To 1000 myconcat = myconcat & ws.