Previous Topic Next Topic

Formating a column using macro

Solved/Closed
Kishore - Dec 27, 2011 at 05:09 AM
 Kishore - Dec 27, 2011 at 10:00 PM
Sir
A forum member helped me in writing a macro to copy certain data from sheet one to
sheet two. I modified basic macro to suit as per my requirement. The macro condition is to copy from sheet one to sheet two by using "paste special" command (Paste spacial with values). The base data in sheet one is in different formats from one cell to another cell. For example, Cell "a" is in date format, cell "b" is in accounting format etc. Now i request some one to help me in writing another macro to change cell formats as per my cell requirements in the sheet 2. The rows in sheet two may vary from time to time.
Kindly help me in this regard.

With regards
Kishore

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 27, 2011 at 02:37 PM
after pasting is done, start the macro recorder to format the numbers to your likening. once done, stop the macro. That will give you a macro that would do what you would like to do
0
Answer 2 / 2
Kishore
Dec 27, 2011 at 10:00 PM
Dear Sir

Thanks for the help. The macro is working.

Kishore
0

Similar discussions

VBA find column by name and sort
SidK -
bOFILL -

4 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses