Linked Questions

I'm trying to paste info to the first blank cell in colum A of a sheet? How can I do this? This is what I have done but it paste the info 1000 times. What do I need to change? Thanks in advance. ...

I'm having an issue where I get stuck in an infinite loop (infinite through the end of the range, that is) with my For Each Next loop. I know that I can't loop backwards, and of course can't have a ...

I'm trying to find a way to find rows with #na so that I can copy the row and past it in another tab so that the error can be analysed. So far I have the following, but I have some problems Dim ...

I want to make Newton-Raphson iteration but stuck on how to incorporate changing Y into the function of interest. For the values of Tpr and Ppr varibles in my code, I expect to have value of Z approx ...

I'm pretty knew to VBA and I'm trying to check if in the specific range of column M if there's a negative number and if it is to change the font to red. This is only working for the first number in my ...

I used Exit For as suggested in Excel VBA - exit for loop to fix the overwrite. I am getting Next without For error on Next j line, which is the second line to the end. For i = 2 To lastrow For ...

The goal of this code is to accept a user input number (New_Project_Number) then read down a list (column A3 to last row of the column) compare the numbers and check for duplicates. Then paste the ...

I have code that searches for and opens a Word file with the same name that value from the cell ("B9"): Sub find() Dim f As String, folder As String, file_name As String Set wordapp = ...

How do I exit the For ITERATION in loop if the condition is met and then go to the next one. The sheet has several thousand lines and such a break in the loop would speed up the code. This is not exit ...

Given the code below. I'm trying to end the for loop as soon as the condition that the value TOTALE ORE has been found. I'm having a hard time figuring this out. Any help is much appreciated. For Each ...