Search results

Thanks Hui and happy Bday!

Hi all, below is the macro I've been working on, and it seems to work, but takes a long time... I had anticipated it would based on what I'm asking it to do with pdf files and the sheer size of the workbook, as well as all the formulae and calculations within the workbook. So I'm not trying to...

you absolute BEAUTY!!! Thanks so much!

Hi everybody, I can not figure out why this code keeps giving me the error... "run time error '1004' Unable to get the Match property of the WorksheetFuncion class" I'm just trying to loop though the values in Column C in sheet "DO NOT DELETE" and return the corresponding row number of the...

Hey Hui, It's beautiful! Thank you so much! I don't understand how deleting the left over photos works... it seems like it does sometimes, but not every time? For example on your latest sample7c file, if I choose 1. APT 2. All properties 3. Save to new sheet in this workbook, the extra...

UPDATE:) So I switched the private sub in the worksheet to my "Add Select Button" macro instead of the "Show UserForm" and it sort of works if you skip the hangups, which now appear to be on .TintAndShade and .ThemeFont instead of .ThemeColor like before... Still no idea what's going on...

Hey Hui, I tried to test out the code on a Full sized version of the report (which I have attached) that I am hoping to use this macro with and these are a couple of things I noticed... 1. The "Select" command button is not created in the current code, I thought I could macro recorder myself...

Wow! I can't even believe my eyes! The only issue i can see is the deleting sheets... as i mentioned before much of the data in this sheet is being pulled from other sheets in the original workbook, which if deleted will result in most of the cells containing REF# errors...is there anyway...

Hey Hui, just got home and checked out the sheet, it looks great! but i have a few questions... if there is a blank cell in row 30 can it just be a warning to the user that those records will not be included, allow them to cancel to go back and edit if they want, or choose to continue with the...

Thanks Hui, i've only got a mac at home and when i opened your sample on it, there did not seem to be any macros attached to the workbook so i will try to run into the office later today to test it on a windows machine. I will let you know how it goes! Thanks, Joe

extract is what i was going for, sort would work too, i just felt like that was impossible :) I still think extract is probably the better option, but whichever is easier or more stable is great!

just occurred to me "run the query" might be the wrong phrase... i meant more like hit the "go" button to continue with the macro :) Cheers, Joe

oh, and i just realized i missed responding to a point in your reply... i don't really want or need a button to activate the user form, i'd kinda like it to just open up automatically. This is actually about the 80% mark of the whole macro so there is code that runs prior to the code i'm trying...

Hi Hui, thanks for your reply! Yes you got it right, as it goes right now, the "Step 3" code copies the main sheet into separate sheets and then deletes columns so that each sheet contains only related columns based on the values in row 30. Right now, these are predetermined as "RET", "IND"...

Hi everybody and thanks in advance for your help! and sorry if my terminology is wrong, please feel free to correct me where this is the case I have posted this thread on another forum as well, but so far no luck. I am hoping somebody on this forum will be able to help me out... Basically...

Hi all thanks for reading, Basically I've got the following Col A-----------------Col B---------------------Col C--------------------Col D Building ID-----------Count---------------------Rental Rate---------------Rank in col A i have a list of building id's, including duplicates as each...