Recent content by tyone

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...