bottoma

Hi All, i have the below VBA code. when a row is marked as "CLOSED" on another tab the row moves to a new tab. but there seems to be an error with the code as it only allows 2 rows in the new tab then starts to overwrite the rows. any help on how to fix this will be highly appreciated...

Hi Iam using the below code ( I found on the internet) and does work great but some of the fields are formulas and I only want to paste the values. I have tried copy.value but get an object required error Thank you Dim bottomB As Integer bottomA = Range("B" & Rows.Count).End(xlUp).Row...

Hi I've got some code which imports some data from a file. I've also got two separate Subs which i) check if a user has selected the right file by checking the text in cell A8 ii) copy the formulas from row 1 into row 5 until the end of the range when data is imported. Although the Subs...

Hi I have a primary worksheet with rows which are numbered according to set criteria. The current list is '1, 2, 2, 3, 4, 5, 5' etc down to 23. I have the following code which was posted by 'mumps' in 2015 (thank you mumps): Dim bottomA As Long bottomA = Range("A" &...

Hello Excel Experts, I want to add a code to clear all sheets data except sheet main (Sheet Name) from 4th row to last used row before updating the sheets in below VBA. Sub CopyData() Application.ScreenUpdating = False Dim bottomA As Long bottomA = Range("F" &...