11.value

So I am trying to paste information into a sheet. When information is pasted i want this code to run. Private Sub Worksheet_Change(ByVal Target As Range)Dim emptyRow As Long 'Sätt fliken lager som aktiv Worksheets("Uppföljning").Activate 'Determine emptyRow emptyRow =...

Hello, I do not consider myself to be a pro at writing the VB code but I am trying and any help that anyone can give me in regards to the following lines of code would be greatly appreciated. When I attempt to run the code I keep getting a End If missing and I have been going crazy trying to...

Hi all again I have code belove to copy row(i) to another sheet if met conditions, it run okey with data under 50 rows but when data over 500 rows code run very slow. Could you have some suggestions or can make this code run more faster thanks in advanced Sub...

i have filtered data and trying to do the calculation with the one row above or one row down of the filtered data .how to achieve that . please advise? Sub GarsButSuspense() c = 64 rc = Cells(Rows.Count, "A").End(xlUp).Row With Range("A1", Cells(rc, c)) .AutoFilter Field:=64...

Hello everybody! New forum user here who is also very new when it comes to coding in Excel. I have encountered an issue where I get Run-time error 13 when deleting or inserting multiple rows. Basically, I want my code to add "-" in a few columns when "TF" is entered in column A. If "TF" is...

I'm getting a "Run-Time Error 1004: Application-defined or object-defined" message during the debug process on this VLookup function. Error is happening on the VLookup, can't proceed further. I got the function to work on a previous section of code, and then adapted it for use in this new...

Good evening, ive been attacking this code for ages and just cant get it to run. its not the tidiest code but it made sense to do it this way in my head. ive created a userform,which I want to transfer into 5 rows in a spreadsheet. the first few columns would all contain the same info, name...