Recent content by Dericki

The error is. "The instruction at " 0x77f83147" referred memory at " 0x00000014" Memory could not be read" Does anyone know what this is and how to fix it? TIA

Here is a cool trick to show Formulas in Excel. Press and hold the Ctrl Key and then press the Tilda Key, once to show and again to hide. Tilda key is right below the Esc Key. Good luck on all formulas hunting.

try this SELECT Table1.amount, round([amount],0.5) AS Expr1 FROM Table1; Good Luck

Did you try in your criteria: 443 OR 444 this should give you all record that product code. Good Luck

Thanks Tony, work like a charm:-D

Thanks Tony, but not exactly what i am looking for. This is what I got so far. Sub CopyRowTo() Selection.EntireRow.Name = "MyRange" Selection.EntireRow.Copy Range("A20").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False...

I could do that, but I have a list of over 1000 rows. I want to select any rows, Row 20 is linked to other worksheet that perform calculation. And no, this is not a homework question, I am too old for that.

I want to copy row 1 to row 20 make change and copy it back to row 1. Now I want to select say, row 4 to row 20, make change and copy it back to row 4.

a b c d e f g 1 10 11 12 2 15 20 25 3 6 8 9 4 . . 20 How can copy Row 1 to row 20, update cell d1 to g1 and then copy it back to Row 1. I need to do this to all Rows. I could copy and put it back, but I am having problems when doung the next Row.