LinkBack URL
About LinkBacks
Is it possible to create a macro that will take a column with each row only having numbers 1-4 and replacing each number in a row with a specific letter??
i.e.
1=A
2=C
3=G
4=T
Attached is a sample sheet that this would be done to...
Creating a Marco to Replace a Specific Number with a Specific Letter in a Column
Is it possible to create a macro that will take a column with each row only having numbers 1-4 and replacing each number in a row with a specific letter??
i.e.
1=A
2=C
3=G
4=T
Attached is a sample sheet that this would be done to...
hi, goldbeje, can you post the expected result for your data provided?
goldbeje,
Give this a try. Change the columns() letter as necessary
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
@Waterserv the attached below is the expected results.
@Tigeravatar ... can I change the Columns ("C") to ("C","D") to reflect the change to both columns at once??
Thank you both for your help with this... I know this question is probably very novice.
Last edited by goldbeje; 10-26-2011 at 09:11 PM.
goldbeje,
Yes, you can change the Columns() line. It would look like:
Please Login or Register to view this content.
It could be wise to use:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks