+ Reply to Thread
Results 1 to 3 of 3

Edit a working macro so it can check a value in a cell

  1. #1
    Registered User
    Join Date
    01-15-2015
    Location
    Oporto, Portugal
    MS-Off Ver
    Microsoft professional Plus 2010
    Posts
    3

    Edit a working macro so it can check a value in a cell

    Good day to all in first place

    I am new to VBA and need some help to edit a working macro so it can check a value in a cell, I do this processe ever month for 500 sheets

    Example of what is working at the momente:

    Sub Imprimir()
    With Worksheets("Francisco")
    With .Range("L4")
    If IsNumeric(.Value) Then
    .Value = .Value + 1
    .Parent.PrintOut preview:=False
    Else
    MsgBox "Cell isn't numeric!"
    End If
    End With
    End With
    End Sub

    Now what I need is to check if cell (D4) has text(employer name) or ( 0 ) 0=employer no longer works with us there for don't need to print

    Hope the information is enough
    Thanks a lot!!!!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello fjrlopes,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    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]

  3. #3
    Registered User
    Join Date
    01-15-2015
    Location
    Oporto, Portugal
    MS-Off Ver
    Microsoft professional Plus 2010
    Posts
    3

    Re: Edit a working macro so it can check a value in a cell

    sorry posted out of place how can I delete the post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vba macro check and add records from working file to other workbooks
    By Jovillanueva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2014, 12:40 PM
  2. [SOLVED] Spell check macro not working :(
    By AdamJaffrey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-03-2013, 05:52 PM
  3. [SOLVED] Allow users to edit ranges not working after running a Macro?!
    By Margate in forum Excel General
    Replies: 2
    Last Post: 02-15-2013, 07:42 AM
  4. Check cell...if not empty copy row (EDIT FOR ADDITIONAL PROBLEM)
    By skip08 in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 09-13-2011, 10:29 AM
  5. edit macro that is pasting info to check column for duplicate info
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2009, 05:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1