[Review] Noblechair Icon Series for Ladies
I always heard people say about a good mattress and chair are important for your health and we should invest…
[How To] C# Excel interop – split data in Sheet1 into multiple sheets based on criteria
I have an excel with lists of data with different categories in same worksheet (as below) and would like to…
[How To] Excel VBA – Copy row to other worksheet (by criteria)
Sub CopyResult() Worksheets(“Result”).Cells.Clear Dim LastRow As Long, i As Long, ws2 As Worksheet With Worksheets(“Work1”) LastRow = .Range(“A” & .Rows.Count).End(xlUp).Row…
[How To] Crystal Report – Looping Parameter and export to individual PDF/Excel (C# ASP.net)
I am using Ms Access in this example, add crystalreportviewer control in your webpage. Create a Crystal report with parameter…
[How To] Crystal Report show blank in ASP.net (C#) in development.
Developer machine: After installation – from this Crystal Report for Visual Studio Look for file “aspnet_client/system_web/4_0_30319/crystalreportviewers13” after installation and copy…
Lost An iPhone in Guang Zhou, China? Here is How You Might Be Able To Minimise Your Lost…
We should purchase travel insurance in every overseas trip. I always do…RM30 for 5 Days travel insurance for ASEAN country,…
Transfer Property under Kasih-Sayang (Love & Affection) – without Lawyer
The process of transfer property under Kasih-Sayang/Love & Affection without lawyer. Save a lot of money! The guide below is…
Car Accident [OD-KFK] Claim – 3rd Party refused to report police
I met an accident recently (11 August 2016), a VIOS knocked on my rear tire & bumper when he made…
[How To] Excel – Remove duplicate value in cell (value separated by comma)
Example: Malaysia, Malaysia & Singapore, Malaysia, Singapore Fix : Malaysia, Malaysia & Singapore VB Module Code: Sub remDup() Dim dic…