failed

Hello all, first time poster here. I've run into an issue and can't figure out how to get around it. I have 3 columns that come into play here, Phase 1 (Pass/Fail), Phase 2 (Pass/Fail) and score. I want to rank only the ones that have passed both Phases, giving the failed ones a rank of 0...

Hi all, I use the following piece of code to copy a bunch of named tables in my Excel-file to a Word document. The tables are named "Question1" etc which are located on a sheet called "Tables". myDoc is an opened Word document For i = 1 To NumberOfQuestions iParCount =...

Hi, I seem to be getting a "Method range of object _worksheet failed" error on my Sub but can't figure out why. It also seems to loop/calculate multiple times before returning the error. I have researched and found out that it is when ranges are not qualified, but I can't seem to locate the...

Evening, All! I've come across a problem that I'm unable to find an answer to. Any help would be greatly appreciated. Please keep in mind that I don't consider myself an expert when it comes to VBA. I have learned a lot in the last couple years, but I'm definitely still learning...

Hi im trying to run a bit of code thats always worked fine before and has not been recently changed however now im getting this error "PasteSpecial method of Range class failed" when getting to the line in red below Selection.EntireRow.Hidden = False 'unhidden Range("A" &...

Hi there.. This is my first post here... I have been using this forum a lot and find it extremely useful, hence I decided to register... :) Anyways, down to business... I am creating a macro for a project and have got to the point where I have been able to sort data in column "A" according to...

Macro Error 'AdvancedFilter method of range class failed' I am using the below code to copy the unique column values from column A to column H in Pivot_Y(Pivot Table) by using UniqueList macro.This UniqueList calling from Worksheet_PivotTableUpdate in Pivot_Y. Later I am moving these unique...

Hey everyone, I'm using an ActiveX Button to trigger a macro which import a sheet of a workbook in my current workbook. Until here no problem, I'm using my GetOpenFilename method, set as a wb, open, move, etc.. But then come the close method! (na na na naaaa) So it make this error, but, if I...

Sorry, but I've spent an hour looking for answers for this problem, and although google returns thousands (probably) of pages of results, I can't find an answer. I was basically wondering if there are any properties that a worksheet holds that stops it from being selected / copied via vba code...