Having trouble with Object Variable or With Variable not set.
Will have sheet with different months records. Need to filter, then copy filtered records to a sheet named either "Calendar2" or "PayPeriod2", depending on dates selected. I can get the filtering done, but no luck on the copying...
Andy,
Sorry for the delay in answering your Q. The patient records are in 2 systems (I don't know why) and the super is wanting to see what is in one and not the other. She exported from both and now wants to compare. I'm not involved in the patient records part, I'm just trying to make her...
I've gotta give both of you a star. Wow.
My super saw what I was doing and gave me a new project. Finding duplicates in our patient accounting records. I have to modify the code a bit, but it should work. If I have any issues I'll be back.
Thanks for the help!
Bill
I am wanting to hi-lite all rows that are duplicates based on the Number, Job and Date. In the following, rows 4,5 and 6 are dupes based on their same values. Rows 7 and 8 are dupes based on their same values. Same for 9 & 10, plus 13 & 14. Problem is that rows 7 & 8 are not being hi-lited when...
Where on this site is info on how to post an excel table or sheet that stays formatted? I want to post some info, but all the columns move together and the headings don't match the columns and everything is a mess. I know how to do code, but not data from a table.
Thanks.
Just curious. Why does the following give an "Out of memory" error? Is it reading every cell in column A? I wouldn't think that that would be an issue.
rng.AutoFilter field:=1, Criteria1:=CStr(Right(Cells, 5)) = "Total
Got it!
I've been using a .Offset and looping thru the lines looking for the cells without the word "Total".
This little bit of code will speed up a currently long process that I use with a couple of procedures.
Thanks PHV!
Bill
After reading and thinking about Skip's reply, I realized that in my haste to post, I got it backwards. I want to delete the rows that do not have the word "Total". Hence, leaving the totals and deleting the detail. Sorry for the backwardness. Anyway, I tried PHV's suggestion except with <>...
I looked thru past posts and did not find anything that matched my issue. I want to delete the rows with the word "Total" after doing a subtotal. I have done a copy and paste special for my subtotals so I can work on them. I have a few notes in the code below.
Sub DeleteRowsWithWordTotal()
Dim...
I want to add a custom menu when opening a wb and remove the menu when closing the wb. The open code works. The closing code does not. Here is what I have:
'Add a custom menu
Public Sub AddTSEMenu()
Dim cbr As CommandBar
Dim ctlMenu As CommandBarControl
'add new menu control
Set cbr =...
I am in need of a new laptop to run Excel. I have no desire to mess with Win 7 or 8.
I have MS Small Business Office 2000 on my current laptop running Vista. Will the Small Business 2000 suite work with XP? XP Pro?
I found the following on the MS site, but I really have no clue as to the...
Hey Skip,
At the moment, all is looking well. The report ran as desired. I plan to go back and update my other VLookUps for consistency and hopefully avoid issues in the future.
Thanks again.
Skip, I did two things that appear to have worked. Or maybe only one of them did. First, I changed the code to:
Dim LastRow As Long
'added Sheets("JobsAll") to the following line
LastRow = Sheets("JobsAll").Range("A65536").End(xlUp).Row ' or
With Range("D1")
.Value = "=VLOOKUP(A1...
The value returned for both columns showing NA are numbers. Col D would be something like .003, .54, .01, etc. Col E will be a whole number such 123, 29, 48, etc.
The same result is asked for with the columns showing NAME.
Also, the info on the source sheet that has the numbers listed...
The value of LastRow is 417263330. It is cell A2445.
I've got a few other VLookUp's very similar to JobsAll!$A$1:$F$ that work. Such as:
=VLOOKUP(A1, CLNTINFO!$A$1:$Z$" & LastRow & ", 2, FALSE)
Isn't the value of LastRow appeneded to $F$. Resulting in the cell range of $A$1:$F$2445?
Thanks.
Skip,
I'm doing it with VBA to automate a very big process. To do it manually just is not practical. I hope I understood what you were requesting with the following. Also, I'm using XL 2010 and every time I want to paste, the screen flickers so I do not know if I'm doing it correctly or not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.