2.select

I use the following formula to extract postcodes from addresses and it works perfectly. TRIM(RIGHT(SUBSTITUTE(A2,"",REPT(" ",10)),20))<o:p></o:p> However, when I insert the same formula in a vba loop, it does not allow me to execute. REPT is highlighted and the dialogue box says "Compile...

Good morning, The code below copy / pastes values from one workbook to another for all identical sheet names. However, when the active workbook contains a sheet not found in the "past wb", an error occurs. How do you tell the code to skip that sheet and continue on to the next (ie "On Error...

I am trying to show / hide some lines (basically to show that this area is Not applicable) Screenshot is here: https://prominent.wetransfer.com/downloads/6b62206a80eab4f41513892cf4499e9e20180522162354/f9d0a56871addac95a4eecc83dea5b2c20180522162354/7d9101 Sub CheckBox22_Change() If...

Hi! I'm trying to select the active cell and all the non-empty cells below it. Can anyone tell me why this doesn't work: Sub Selecting() Dim Lastrow As Integer Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row ActiveCell.Resize(Lastrow, 2).Select End Sub Thanks!