Recent content by hrm1220

Is there a way to ONLY copy the formula and not the conditional format? Each time I copy a cell it brings the conditional format with it regardless if I paste special formula or a regular paste. I have 300 rows and over 256 columns with conditional formatting. Any help would be greatly...

I have several worksheets with a pivot table on each worksheet from OLAP source in Excel 2007. The goal is to get the group1 (Parent), group2 (Parent child),and group3 (child). example: Group1 (the variant VarField (1,x)) Mammal Group2 (the variant VarField (2,x)) Dog Group3 (the variant...

I'm hoping someone can point me in the right direction. I have 2 tables that are 30K+ rows. I've put them in arrays. 1. need to find unique ID from myarray in the 2ndarray 2. if finds unique ID in 2ndarray a)need to check to see if certain criteria match b) if doesn't match criteria find...

I appreciate the inputs, but it seems that vb script doesn't like "With objWorkbook.Connections("Connection1").ODBCConnection" or "objWorkbook.Connections("Connection1").ODBCConnection.Refresh" So, I'm not sure what to do. All I would like to do is have it open a workbook in excel 2007 and...

thank you for that. when it's running it shows that it's completed, but when I open the file the MSQuery tables are not refreshed. This script is run in the middle of the night. My next question is how do I enable the data connection through code? here's what I have so far: strInput =...

I'm very new to vb script. I've looked on the internet and haven't quite found what I need. I have a script that works for the most part, but it doesn't give excel time to refresh all the QueryTables (takes about 3min to refresh). So, I'm wondering if there is code to put in for delay before it...

ok. thx for pointing me in the right direction Skip... I just needed to declare my datevalue. Cells.Find(varList(3, x)).Activate chCol = ActiveCell.Column timesplit = Split(varList(4, x), "/") timestart = Mid(timesplit(2), 8, 6) datesplit = Split(varList(4, x), ":") timematch =...

I still get error 2042

I've tried that and it gives me a type mismatch. It maybe that the source data has the date/time and the PM/AM after it. Could this be the reason why? So I used the split to take out the AM/PM but it still gives me a type mismatch error.

I collect information from "Start" sheet that has the date and time, which is stored in the varList (but is seems to store it as text). In my "Report" sheet I have the minimum time (I get this from the "Start" sheet) as the starting point. Then add 30 seconds to each row. What I'm trying to...

ok. well sorry for once again bother you guys. It actually does work. Again thx for looking for me

thx I've added the Err.Clear, but I'm still having problems with the .Placement=xlMoveAndSize The code is not selecting this for the comments properties. Can you point me in the direction on where I messed up the code?

I'm trying to fix the "Cannot Shift Objects off sheet" by looping through all the cells in a workbook. If the cell has a comment I want to change the properties of the comment to "Move and Size" (xlMoveAndSize) with the cell instead of the "Dont move or Size with cells" (xlFreeFloating). I...

my apologies for not being clear. I was looking for the max value based on the 2 criteria given in the 1st section of the sumproduct, so I was trying something like...

I have the following formula which works. But now I'm being asked to only provide the max value and not the sum, based on the 2 criteria. SUMPRODUCT(--(('[test.xls]Sheet1'!$AA$1:$AA$10000=$C13)*('[test.xls]Sheet1'!$W$1:$W$10000=K$1)),'[test.xls]Sheet1'!$V$1:$V$10000) So is there a way to add...