lngloop

Okay this is what I am trying to do. I need to take a Hex value and have it returned in reverse Byte pairs as in the following diagram For instance the top line (480000074B26E42D) being the original hex value, then reversing it so that the outcome = 2D E4 26 48 07 00 00 48 I have tried using...

Hi all, I am updating an old macro and trying to use the replace function instead of two nested loops that process every character in the columns to remove all spaces, commas and dashes in the strings (addresses). My macro runs but does not replace anything. At the moment, I can get neither...

I have the following code to open up a csv file I am trying to autofit all the columns and then save and close the file However when opening up the file, the columns are not autofitted to the length of the largest item in each column Kindly amend my code below so that the columns autofit...

Hi there, wondering if you could help me to make the below. I have a workbook with more then 20 sheets. My goal is to make each tabs change colour if a specific text is found on column N I have managed to write the below code, but it takes 10 seconds for it to complete the task. It is worth...