Search:

Type: Posts; User: 123DavidRhodes; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Find value with criteria then copy row

    If that's your entire code I would put this line in first and it will speed up significantly:

    Application.ScreenUpdating = False
  2. Replies
    7
    Views
    186

    Re: Merge two Worksheet_Change codes

    I never knew that. I am new here. This is my first day. I will do that in the future
  3. Re: VBA skip to certain section in Macro if cell is blank and issue different msg box

    What I like to use to do what you want is this:

    If Range("B16").Value = "" then
    GoTo Line1
    else
    GoTo Line2
    End If

    Then put Line1: where you want to skip to and Line2: where you want to skip...
  4. Replies
    7
    Views
    186

    Re: Merge two Worksheet_Change codes

    No where that is a comment not code. I modified the code to the range of cells you specified. I simply did not change the comment is all, sorry. You're free to change it if you like. It will have no...
  5. Replies
    7
    Views
    186

    Re: Merge two Worksheet_Change codes

    No where that is a comment not code. I modified the code to the range of cells you specified. I simply did not change the comment is all, sorry.
  6. Re: VBA Code for Inserting Rows Based on Cell Value

    Try working with this code and customize it to your needs. If you have questions you may reach me at (123 davidrhodes at gmail dot com)

    If ActiveCell.Value = "IQ4" Then
    ActiveCell.Offset(1,...
  7. Replies
    7
    Views
    186

    Re: Merge two Worksheet_Change codes

    This should work but I'm not 100% this is what you're looking for:

    Private Sub Worksheet_Change(ByVal Target As Range)

    ''''''''''''''''''''''''''''''''''''''''''''

    'Forces text to UPPER case...
  8. Re: Import Excel Data to Access Table - Retain Primary Keys

    Hello,
    Based on the dynamic nature of the excel file, if it were me I would link the excel file in Access. Any changes to the excel file will be realized in real time in the access table. Go here to...
Results 1 to 8 of 8