Search:
Type: Posts; User: ajk79
Search:
Search took 0.03 seconds.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
That worked perfectly. Thank you so much!!
Below is the code that I ended up with
Sub Auto_Open()
Call ToggleProtect("BENCHSHEET", "Off")
-
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"
-
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...
-
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...
-
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...
-
This worked perfectly. I thought I had tried something similar, but apparently had something wrong.
Thank you so much.
-
Sorry, the msgbox parts were confusing my. I will try the suggestions and let you know.
Thanks
-
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...
-
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...
-
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...
-
I tried the second one and it worked great.
Thank you for your help.
-
I am sorry I put parentheses and I meant quotation marks.
-
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...
-
Sorry, yes I am using the visual basic editor within excel to do this. I wasn't aware of the difference.
-
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...
-
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...
-
Nevermind. I was able to figure it out myself.
Thanks
-
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...
|
Click Here to Expand Forum to Full Width
|