Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rating: Thread Rating: 6 votes, 5.00 average. Display Modes
Old 07-19-2011, 11:23 PM   #1
evanhughes
Newly Registered User
 
Join Date: Nov 2009
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
evanhughes is on a distinguished road
Modify cells macro

Hi All

I have a macro which deletes line 2 of a csv file and converts all values in existing cells in columns K to AC to a currency format. This works well.

What I need to add is code to check column D and if cell value is "OWO" then modify cells in columns K to AC in same row to 0 (zero).

Any help on code to add to my existing macro would be very appreciated.

Regards

Evan

evanhughes is offline   Reply With Quote
Old 07-19-2011, 11:35 PM   #2
Brianwarnock
Retired
 
Brianwarnock's Avatar
 
Join Date: Jun 2003
Location: Merseyside England
Posts: 12,701
Thanks: 39
Thanked 538 Times in 520 Posts
Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light
Re: Modify cells macro

If you are asking people to modify code it would be useful to post that code,, however it should be simple for you to check col D and set the values in K to AC since you are already setting the format

Brian
__________________
What is this life if, full of care,
We have no time to stand and stare

I do not have Access these days 2015
Brianwarnock is offline   Reply With Quote
Old 07-20-2011, 12:11 AM   #3
evanhughes
Newly Registered User
 
Join Date: Nov 2009
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
evanhughes is on a distinguished road
Re: Modify cells macro

Brian

Thanks for the quick reply.

The code is attached in a text file.

Evan
Attached Files
File Type: txt Code.txt (1.5 KB, 50 views)

evanhughes is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Export a Field and Find/Modify a Template Cdata Macros 3 07-19-2010 09:42 AM
Macro to Modify SQL Query LadyDi Macros 1 04-20-2010 07:13 PM
How do you run a macro to modify a form sandi1970 Macros 3 05-21-2009 11:05 AM
Macro to edit cells esskaykay Excel 2 08-10-2006 09:52 AM
[SOLVED] Protecting Cells Macro Warning lisamcginley Macros 0 05-06-2006 12:07 AM




All times are GMT -8. The time now is 04:39 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World