LinkBack URL
About LinkBacks
Hi,
I tried to write a macro, it works fine but as I am learning I wondered if there were any pitfalls or perhaps something I have missed.
Your guidance will be greatly appreciated.
Thanks
Please Login or Register to view this content.
Hi,
I tried to write a macro, it works fine but as I am learning I wondered if there were any pitfalls or perhaps something I have missed.
Your guidance will be greatly appreciated.
Thanks
Please Login or Register to view this content.
What is the purpose of your code?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
If column heading is "CASH_CODE" filter for "BATRANS"
Copy cells containing "BATRANS" from column "CASH_CODE" to column "ELE_CODE4" then replace "BATRANS" in column "CASH_CODE" with "-"
Hope this makes sense
Is the code giving you any errors currently?
Hi Arlette,
Yes it doesn't work if there is only 1 row containing BATRANS, I am concerned I may have missed something as I am a novice.
Ta
Last edited by kaseyleigh; 02-22-2012 at 05:42 AM.
You can start getting rid of the select & activate statements. It makes the code longer and takes time to run as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks