Search:

Type: Posts; User: ajk79

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    571

    Checking Date Function Problem

    I have a form that has various boxes. Some of these ask for the date something was done. I need to check if that was greater than six months ago and give a msg box if it isnt. The code below...
  2. Replies
    15
    Views
    100,280

    Re: Runtime Error 6 Overflow

    WestConn1,

    Thank you for your help. I had to change the code a bit for it to calculate the way I wanted. The code below is what finally stopped the overflow issue.


    For Each cell In...
  3. Replies
    15
    Views
    100,280

    [RESOLVED] Runtime Error 6 Overflow

    I have the following code that keeps giving me a runtime error 6 "overflow". I have read that it is usually caused by too much information being processed a the same time, but I am not sure how to...
  4. Thread: Runtime Error 13

    by ajk79
    Replies
    3
    Views
    625

    Re: Runtime Error 13

    I have a set of data that is only going to populate in rows 12-40. For any of this data, if column C = DUP then I need the percent difference of that rows P cell & the previous rows P cell. This...
  5. Thread: Runtime Error 13

    by ajk79
    Replies
    3
    Views
    625

    Runtime Error 13

    I get a runtime error 13 - type mismatch when running the code below. The following line is the highlighted line when I click debug.

    ElseIf Cell.Value = "DUP" And Cell.Offset(0, 13).Value >= 10...
  6. Replies
    2
    Views
    2,047

    Runtime error 1004

    I am receiving a runtime error 1004 application defined or object defined error
    when I run the code below. The line highlighted in blue is where what shows up when I select Debug. I cannot find...
  7. Replies
    4
    Views
    591

    Re: Worksheet_Change Error

    I took the parentheses out and placed the


    Application.EnableEvents = False
    Application.EnableEvents = True

    around the code that I am using for the pasting of the range of cells, and the...
  8. Replies
    4
    Views
    591

    Re: Worksheet_Change Error

    I still get the error.

    It is happening when another set of code is being run. My other code copies and pastes a range of cells from one sheet to another. When the range is pasted some of the...
  9. Replies
    4
    Views
    591

    [RESOLVED] Worksheet_Change Error

    I have several worksheet change events in a file and am having a problem with a few of them. I have it set that if a specified Cell is > 20 a code runs or if it is < 20 a different code runs. The...
  10. Re: [RESOLVED] Cell Value based on identical cells in two columns

    koolsid,

    The code does exactly what I need. I had to remove the SearchFormat:=False, but other than that, it is exactly what I needed. Thank you so much. This makes my code much cleaner. Thank...
  11. How to Open a space deliminated text file in Excel

    Hello,

    I have a software program that exports a report as a fixed space deliminated text file. I then need to open up this file up in an excel workbook with the data in separate columns. I...
  12. [RESOLVED] Cell Value based on identical cells in two columns

    I have an excel project that is imports a list of project numbers from our LIMS system and puts them in Sheet("CBOD") Range("A12:A37"). I then have a run log that is imported into sheet("PASTE"). I...
  13. Replies
    6
    Views
    600

    Re: [RESOLVED] If Then Statement Problem

    That worked perfectly. Thank you so much!!

    Below is the code that I ended up with




    Sub Auto_Open()

    Call ToggleProtect("BENCHSHEET", "Off")
  14. Replies
    6
    Views
    600

    Re: If Then Statement Problem

    It is still not showing up when the file is named

    "C:\AEL\CBOD\Day 1 Finished Runs\CBOD_RUN_" & myDate & ".xls" Or
    "C:\AEL\CBOD\Works in Progress\CBOD_RUN_" & myDate & ".xls"
  15. Replies
    6
    Views
    600

    [RESOLVED] If Then Statement Problem

    I have a excel project that when it opens frmSTARTUP shows. If the project opens from a certain path and name I need some of the buttons on the form to be disabled or for it not to show at all. I...
  16. Re: [RESOLVED] Save Excel sheet as CSV file Problem

    Thank You koolsid. This worked in that it saved only the sheet in question and had no macro in it. I was hoping to keep the original workbook open, but I have figured out a way around that, by...
  17. [RESOLVED] Save Excel sheet as CSV file Problem

    Hello,

    I have a workbook that has numerous forms, command button, etc. I have code that takes data from one sheet and puts in in another sheet formatted to what I need. I need to save just the...
  18. Replies
    6
    Views
    667

    Re: Naming Variables Problem

    This worked perfectly. I thought I had tried something similar, but apparently had something wrong.

    Thank you so much.
  19. Replies
    6
    Views
    667

    Re: Naming Variables Problem

    Sorry, the msgbox parts were confusing my. I will try the suggestions and let you know.

    Thanks
  20. Replies
    6
    Views
    667

    Re: Naming Variables Problem

    I am trying to make the chuck of code at the bottom easier to look at. The code works, but I will have about four others like them that are all referencing the same group of 15 cells. I figured if...
  21. Replies
    6
    Views
    667

    [RESOLVED] Naming Variables Problem

    I have the following code that does a calculation based on several different criteria of other cells. I was trying to assign variables to all this different cells so that the whole calculation is...
  22. Replies
    6
    Views
    1,068

    Re: Page Breaks for Pasted Rows

    I am not quite sure what you mean by test the collection for pagebreaks. I see a where you can add and count pagebreaks, but how exactly would this help. I need to be able to have the program...
  23. Re: Remove parenthesis from a Cell Value

    I tried the second one and it worked great.

    Thank you for your help.
  24. Re: Remove parenthesis from a Cell Value

    I am sorry I put parentheses and I meant quotation marks.
  25. [RESOLVED] Remove parenthesis from a Cell Value

    I have an instrument that when a button is pressed it sends data to my excel sheet (Using Winwedge). The Date and Time come through with parentheses around them (i.e. "11/04/10"). Is there anyway...
  26. Replies
    6
    Views
    1,068

    Re: Page Breaks for Pasted Rows

    Sorry, yes I am using the visual basic editor within excel to do this. I wasn't aware of the difference.
  27. Replies
    6
    Views
    1,068

    Page Breaks for Pasted Rows

    I have a program that is adding rows of varying number to an excel sheet. I was wondering if there is code to specify that if a set of the pasted rows are going to be split by a page break to add a...
  28. Re: Calculate a Cell Value based on numerous conditions

    Sorry about that. This is the first time posting to a forum.

    How the program works it the person sets up the page by clicking command buttons. There are ones for the 3 row, 4 row, and 5 row...
  29. Re: Calculate a Cell Value based on numerous conditions

    Nevermind. I was able to figure it out myself.

    Thanks
  30. [RESOLVED] Calculate a Cell Value based on numerous conditions

    Hello,

    I am relatively new to VB6 and have been teaching myself. I am writing a program and have come to a point where I cannot figure out how to code a calculation. I have attached a sample of...
Results 1 to 30 of 30



Click Here to Expand Forum to Full Width