Recent content by EVE734

Skip - It worked! You've helped me in the past as well - I really appreciate it your taking the time to help a novice through the fascinating world of VBA! Sincerely, Evelyn

1) The only thing on the Print Sheets is a "header row" in row A, so that when the data from "Journal Entries" is pasted, it is clear what the data represents. 2)The Journal Entries sheet has multiple rows of data which I need to keep as is, but for some users who will be viewing the file, I...

Thanks so much Skip. I am getting an application-defined ir object-defined error (run-time error 1004), with the following section highlighted: .Cells(.[A2].End(xlDown).Row + 1, 1).PasteSpecial _ Paste:=xlPasteValues, _ Operation:=xlNone, _...

Hello, I am trying to create a macro in Excel in which for a given range of data, say A32:L100, if a cell in column C has a certain value, the macro will copy and paste data from that row onto another sheet in the next empty row. Below is an example of the code I have, which gives the right...

I spent all morning trying to get this - Thank you so much Skip!

Sorry for the confusion. I do not want to print range CC6:CC10. Cells CC6 and CC10 use "address" formulas to obtain the print range that I actually want. The print range will vary as I have multiple columns and rows which will be hidden based on certain criteria. The value in CC6 in this...

Hi - I am trying to create a macro in Excel which will update the print area range based on cells I have designated using an "address" function to locate specific start and end cells. I am a novice user and tried to use the "record macro" feature of Excel. The code I am trying to manipulate...

Sorry for my confusion regarding XP / 2007. I just knew it was related to a system-wide upgrade being done by our IS dept. I will take a look at the reference and try to figure it out. Thank you.

No, on the computers that have not had the upgrade (and where the field is still working), the references are the same, except for Microsoft Access 12.0 Object Library, which is Microsoft Access 11.0 Object Library in the older version. I am somewhat concerned as all workstations are scheduled...

Lisa - My apologies for the delay in response. I have finally had a chance to take a look at this, and the active references are as follows: Visual Basic For Applications Microsoft Access 12.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Windows Media Player...

Lisa - Thanks, I am having someone from our systems department looking into it right now to see if there was a problem when the upgrade was done to the workstations. As for it being a DAO/ADO problem, I'm afraid I don't much about that. I'm very inexperienced with this. Is there something...

Thanks - When I use the expression builder, there are two ways to select the subform. The options to select from are: Interface_Screening_Form (the main form, which this subform is a part of), Tables, Queries, Forms, etc. If I select the subform under the "Interface_Screening_Form" choice, the...

Thanks PH - I just tried it, but am having the same trouble. Evelyn

Hi - I have a control on a form with its control source set to: =Interface_Rejection_Subform.Form.RecordsetClone.RecordCount (to count the number of records on the referenced subform). This works fine on non-xp workstations, but for several users who were upgraded to xp, the control shows...

WOO HOO!!! THANK YOU SO MUCH!!! You Tek Tip guys are the best!!!! Much appreciated, Evelyn