Recent content by hu5

Hi, I tried to reformat my laptop, but lost the original SERIAL # of the WinXP CD. Is there a way to retrieve serial # from my system ? Thanks.

Hi electronicsfreak, To respond your question, I completely erased it then install a fresh copy of windows XP. Your further feedback is greatly appreciated.

My Win XP freeze in 1-2 minutes when first startup, sometimes, it gives noise. Restart pc will resolve the problem. After I reformatted pc, the problem persisted. Is this a hard drive problem or some other parts? Thanks for your feedback. Hu

Thanks dnevill for replying. I assume you are referring to Tools - Extensions, There's no extensions to remove, it's disabled - not compatible with Firefox 1.0.3 Hu

Hi, After upgrading firefox at prompt, the browser failed to load. I uninstalled firefox, and reinstalled it, still not working. It's all blank except the browser border, and error message reads: can't not find this site... Thanks for any suggestion. Hu

Thank you, Kevin and Ken, you've been very helpful and kind. The macro works now, must select the rows to be concatenated, and it will do the trick. Hu

Kevin Thank you for the great code, it works with 10 rows even 20 rows, but when I change NumberOfRows = 20262, it ran a long time but didn't work at all. I tried with 10 rows again, it's not working either. I closed file & reopened, still not working. macro is enabled. Do you know...

Ben, The formula =OFFSET(A$1,(ROW()-1)*2,0)&" "&OFFSET(A$1,((ROW()-1)*2)+1,0) works beautifully, but when I delete the original range A1:H20, I got #REF! error value in every cell range of A1:H20, and the new paste data are all gone. How do I fix this problem? Thanks. Hu

for Kevin, Yes, your macro works, thanks very much. As I'm new with macro and would like to have more information. Although Each web page contains only 10 records, my files is as big as 15,000 records. I wish to cut 30,000 rows in half. This macro only works when select a row, and...

Thank you all. It's a secure website requires login. But the example as follows: The format in Excel after copy from the website looks like the following, one records split in two rows, all columns have values in them. A B C 1 first...

Hi, I copied a spreadsheet from a website, then pasted it in the Excel worksheet, it's a 10 rows table, but due to the key entry by the author, Excel made it 20 rows. Is there a way to combine every 2 rows (a record) into one row in Excel? Thanks. Hu

Hi I put a command button to move 2 types of records. But have problem using MsgBox for user selection. I try to modify the system MsgBox, but it didn't sound right. How do I replace "yes" and "no" to "ARCHIVE" and "INACTIVE" option? Thank you for help. Private Sub MoveRecord_Click()...

I have 2 combo boxes, "findRecord" retrieves record based on "SRM No", the other "Type" which has several types like "Cert";"Report";"MSDS";".... Some records have duplicate "SRM No" with different types. for example: 114p Cert and 114p MSDS.... When user search the record with dup "SRM...

Hi, Originally, I put 2 command buttons which move 2 types of records to 2 separate tables. Now, I combine these 2 command buttons as one, and it has 2 selections, yes/no. If the user select Yes to move completed records, it works, but if they select No to move archive records, the...

I put a command button for user to move 2 type of records to 2 separate tables: The caption is "Move completed/inactive records to archive". When user click the button, it should give 2 choices, "completed" and "inactive", like msgBox or pop-up. I don't know how to use the msgBox...