thisworkbook

Hey everyone, I'm trying to define two ranges composed of non-contiguous columns located on 2 separate sheets (Sheet1 and Sheet2). The script does work with one sheet but it ignores the ThisWorkbook.Worksheets() located in the second With statement and simply selects the range on the same Sheet...

Dear All, Background: I am an experienced programmer but a novice with Excel macros and VBA so please bear with me. Summary: I have a situation where I want to turn error checking off and back on again for specific Excel files but not for all files i.e. not for the entire 'Excel'...

Hi All, I am very much confused by this error. I have a user defined function in my workbook. It runs fine usually however when I open my workbook an error is displayed "Automation Error" I click ok and it enters debug mode on my UDF. if i make the udf refresh it works fine. My UDF is in a...

Help! Trying to open a file using vba and then go back to original file that holds the code below. Ultimately trying to do a vlookup using two workbooks but can't get past this point. Getting an object required error and stops at last line of this code: Sub Format() ' ' Format Macro ' Dim...

I am trying to stop calculations in a single workbook while maintaining calaculations on in another workbook. I have the workbooks set up to run set calculations when different parameter change but haveing calculations constantly running on one of the workbooks locks Excel for 15 to 20 minutes...

Hi, I keep getting a break referring to "ThisWorkbook". Can anyone help? For i = 2 To lastline Columns("AL").Replace _ What:=ThisWorkbook.Sheets("Metric").Cells(i, 1), Replacement:=ThisWorkbooks.Sheets("Metric").Cells(i, 2), _ LookAt:=xlWhole, MatchCase:=False Next

Hi All, I am writing a macro that starts in one workbook (who's file name will change weekly) and will also access a reference sheet on the network. The goal is to copy the reference sheet into the first workbook. In order to do this I'm using the following code, but I am not getting past...

Hi, I'm trying to copy data from a Workbook to the Master Workbook (Containing Macro). I created the following formula that keeps breaking. With Thisworkbook.Sheets("Data").Range("A1").Select .Range("A65536").End(xlUp).Offset(1, 0).Select ActiveSheet.PasteSpecial...

I have been working with a simple macro that I have recreated several times. I normally put it into Thisworkbook or into its own Module for the file I'm working with. Each time I needed to check against a new manufacturer I exported my required information and retyped the macro. For Each r...

Hi all, I'm having an issue and I don't know how to start. There is a workbook that our company sends out to outside parties and we would like to prevent those people from cutting/copy/paste. This workbook is a data dump from our ERP system that then runs through a fairly complex macro to do...

Hi, Hopefully somebody will be able to help me. I'm developing an excel addin using Visual Studio 2008. At the moment i'm trying to display a popup showing the value contained in cell A1. However, i'm getting a runtime error saying that xlWorkBook is null. I've been able to get this to work if...