Can you add a sample worksheet, as the above doesnt make a lot of sense to me. =IF($F9=$AB$4:$BV$4,$Y9,"") looks like an array formula (so Ctr...
Okay, so the below code will copy the cells from the selected row as ask you to type in a destination row number Sub CutNPasteSelectedRow() Dim ...
not sure what your data looks like, but you seem to be counting the rows in column F with LastRow = Cells(Rows.Count, "F").End(xlUp).Row 'the "a" i...
Looks like the data has been input in 2 different formats - rows 2 to 5498 show (for example) 999-04-0558 but the number is really 999040558. The seco...
The above code takes the number entered in A1 and adds it to the value in B1 - so the first time you input 2 in A1, a1 will show 2, then you input 10 ...
For a variable length column you can add a variable like the below then use that as part of the range Sub LastRowX() Dim LastRow As Long La...
Assuming you want to just delete the contents of the cells? Sub DeleteSelectedInRow() Dim r As Long Dim ColsCount As Long ColsCount = S...