Search results for query: *

i recorded a macro that shows what happens in the copy and paste and the macro shows you select rows with the following code: rows("35:35").Select if i am keeping count of the row using lngRow isn't the following code the same. rows(" & lngRow & ":" & lngRow &").select but this will not...

why does it need the & symbol in there. just curious. also is there a way to bold those cells also. thanks so much in advance

thanks PHV was just what i was looking for....

#NAME? the code behind this: ActiveSheet.Cells(lngRow, 7).Formula = "=sum(rng:rng1)" rng and rng1 shows the cells that they should be like $G$2 and $G$5. Thanks in advance

PHV that code gets a error 13: type mismatch at the timevalue statements. any ideas as to why.

wouldn't that only loop until it hit the first 7:00 then step out of the loop.

phv could i use "b:b" as the range and the same as d

i added the range because i thought it was getting stuck on the first row which is a header row. but when i step thru this it errors out on the timevalue statements. Range("B2:B500,D2:D500").Select Do While x = 0 If TimeValue(Range("B") <= #7:00:00 AM#) And _...

hey phv i am getting a runtime error 1004 at the timevalue when i try to step thru this any ideas as to why.

skip the spreadsheet is from is a access database from our extrusion press. i am trying to make so that we can keep track of how many pounds of metal, billets is pressed per shift, and daily totals. so what i am trying to do is find where the shift changes are 7:00 15:00 and 23:00 and then i...

hi skipVoight, As of this point of time i have no code. i have looked at it thru the find feature in excel and recorded that into a macro and looked at that but that seems to be looking at one cell at a time and not for what falls between the ranges. i am not sure if it is a lookup of some...

i am trying to figure out a way to add three rows after i find a particular time. i have columns b and d set formated as time columns. i am looking for a way to go thru the worksheet and add three rows after i find a time of 7:00. the time can be either in column b or d or fall between the...

hi skip yes i have looked into that but this file at the present time is getting close to 5000 rows of data. so i want to find a value then automaticlly insert a line and yes i will then use the data/sub totals part of it.. yes i understad that i could also use the find feature from excel...

cbasic i don't have any code for that as of yet. what i tried was to dim a variable as string and put that in front of the formula but then it comes up with a compile error. i am not sure what to use for the code. i do all most of my programming in rpg so i am lost as to programming in vba...

what i am trying to do is look thru a spreadsheet by columns and find a value. if that value is found then i need to know what the cell refrence is so that i can add a row beneth it so i can do subtotals under it. the find works but i don't know what the statement is for cell refrence. i know...

ok i see what u are saying now..... damn hit me up along side the head with a bat... thanks for all of your help and time. don

ok i have added the invite kwd in the dds dspf and have set the waitrcd to 5 it still doesn't end. it has sat there since before lunch time. after i made the change to the dds i did recompile the rpg program also.

MdnghtPgmr email me at djmajr@hotmail.com it is just to show the employees if they have punched in or not. no the only keying in is done on the intial screen. that screen has to wait until the user hits enter. the other two screens only say john smith u are punched in and what time he...

ok i write the record i call the clp with a dlyjob. at this point my display has not shown up. if u do either a read or exfmt the display will sit until the the user presses the enter key. i understand that this is by default but i don't want my user to have to press the enter key. i want...

MdnghtPgmr, the display sits there until u press enter by default. What i want to do is have the display show for 3 to 5 seconds and then end as if u have hit the enter key.