targetrange

Im updating a sheets rowsize but when its saved, the size of each row isnt adjusted. Any Ideas? Thanks wb.Sheets(1).Range("U:U").ColumnWidth = 10.56 wb.Sheets(1).Range("W:W").ColumnWidth = 50 wb.Sheets(1).Range("X:X").ColumnWidth = 50 Set targetRange = Range("A:A") For...

I have the following code which works perfectly. What I now wish to do is loop through all worksheet sin Wb except sheet1. I have tried to use a For Each Loop and an If statement trying to exclude Sheet1 but it wil not compile with the message that I have a next without a for. I have tried many...

Hello, I have a VLOOKUP macro using the below VBA code. The idea is to take a list of UserID's (on Sheet1/Column A), and populate information for each user (Name, Job Title, etc.) based on a fairly large table array on Sheet2 of the Workbook. My question is, can this be modified in such a way...

Hi all, I have written a short bit of VBA that runs fine for me but when a cell is selected and delete is pressed the code runs but on the cells and rows above it (Offset is used) not to the right as written. What I am trying to do is to get the sub to recognise when delete is pressed in the...