Hi
i have one doubt.
previously, i used to convert text values in entire columns to numbers at once without using "Loops".
Here is the Code.
Range("d:h") = Range("d:h").Value
like above code
i) i want to convert date&time column to date(mm/dd/yyyy) at once on same "A" column( With Out Loops)
(1st column (Sold On) in attached sheet. )
ii) i want to extract partial data from one column to another column at once. (without using loops)
(in Attachment, For explanation, i used formulas and date formats . But Actually, I need VBA Code for both columns)
regards
shiva
Bookmarks