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

#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

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

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

I have a rpgle program and want to make it easier for the end users so they don't have to hit return to end the display. The format of the displays are all records. The first one asks for employee number. it then will either answer with a yesno display, but i want the yesno displays to...