Linked Questions

I don't know what is wrong with this code. it shows an error at Rng.select. When i tested on a separate sheet it worked. Any help?. Sub copyex() Dim Lastro As Integer Dim oSht As Worksheet Dim Rng ...

I am trying to have a search by cell value I dont know if the code I have is my best choice. and Im having errors with it, I want to search a cell value from another sheet "Family Ref" in ...

I'm having an issue with a section of code is being flagged by the debugger, but I can't figure out why. Section 1 is copying a sheet and renaming it a cell value. This section seems to work fine. ...

This script works fine when I'm viewing the "Temp" sheet. But when I'm in another sheet then the copy command fails. It gives an Application-defined or object-defined error: Sheets("...

This problem is driving me crazy. I have the following code: 'unprotect sheet If.Range("Start").Row+1<.Range("End").Row then .Rows(.Range("Start").Row+1 & ":" & .Range("End").Row-1)....

I am trying to select a cell by giving which row and column to use. It is giving me an error: "Unable to get the select property of the range class." when I get to this line: Sheets("...

Please help! The last line of my code 'Sheets("Original Data from Server").Cells(4, 2).Select Will not work! Keep getting error "Select method of range class failed' Whenever I only run that one line,...

this is my first post on StackExchange! I've been using StackExchange for answers, but now i really have a question. I am trying to add a column in excel using vba. This is procedure is part of a ...

My purpose is to copy rows from another Excel workbook and paste it back into my original Excel workbook This code works perfectly well if i remove line 2 and test it on my original Excel workbook ...

I'm writing a process that needs to loop through all Excel files in a folder and save each one as a pipe delimited value. I've done a lot of hunting on how to do this and most of them say to change ...

I have created a form that adds information to a sheet. The data is added to the sheet by clicking an "ADD" button. Once added to the sheet, It then selects all data in the sheet to sort ...

I am relatively new to VBA and need some assistance. I have been piecing together this application from other bits and samples. This was working on Friday but now it isn't and I don't understand ...

I am getting stuck between two errors. I am trying to create a module to copy data from one tab of a workbook and then paste it into another. When I run code A: Dim N As Range Dim Out As Range Dim c ...