defined

  1. M

    Help needed with a text field that starts vba command that filters

    I need help for my following issue which I haven't been able to solve. . I have a defined text field in my sheet and when entering a text (characters) or numbers (digits) it starts executing (filtering) right away. That takes some time. Is there a way to define by the user when the vba command...
  2. R

    Object variable

    Hi all, I am bit new to VBA world. I am having one doubt. Is it possible to edit or manipulate a cell data if it consist in a range that is defined as object variable? What I am thinking is if we have a range of cell defined as object variable then we can make changes to that full range of cell...
  3. P

    Dynamically updating charts and non-sheet specific named ranges?

    Hi everyone, first time posting here. I've been hitting my head against a wall on this particular problem for a few days, and I could use some help. I'm using Excel 2016 and would like to avoid VBA. I have a bar chart (as an object within a sheet) that uses named ranges and the offset function...
  4. S

    Misbehaving Chart Data Sources

    This code is doing everything I want it to do, except the output is wrong. Specifically, when "chartstring" is defined, it is defined by the sheet "Summary" from a range spanning A2 to my desired column--but row 3 instead of 2 as is hardcoded into the definition! What's going on here...
  5. F

    Help pasting to another workbook

    I just want to copy from one workbook to another but I always get errors ranging from Application defined or Object defined errors to compile errors to the paste area must be the same size as the copy area, I didn't realize how hard copying and pasting something would be. This is my code so...
  6. K

    Macro to Insert text in a cell based on a condition.

    Hi all, I have a excel sheet , In J column i have 'Policy Type' , In AK Column I have 'Final Status'. I am looking for a macro code that can search 'Renew' in Column J (Policy Type) , Against all Renew in Column AK , it should insert 'To be Defined'. <tbody> Policy Type (J Column) Final...
  7. G

    Trying filter multiple columns

    I am new to Excel vba and am trying to filter records based on certain column selection. 1st I would like to filter out all #Div/0 errors and 2nd I would like to filter for only records ">=" a user input box. I'm using the following code: Dim StartDate As Long Dim temp As String temp =...
  8. X

    how to ignore range within defined range

    Hello I have a defined range of 16 LED's but I want (i) to ignore the LED's 13-15 but still do 1-12 and 16 how can I do this? If Sheets("Intro").Range("CHOOSE_LED").Value = "CLASSIFIED" Then For i = 1 To 16 '16 LEDs
  9. H

    How do I use VBA defined variables in a function?

    i've defined a variable in vba and am now trying to get a function to call it. the value assigned to the variable is correctly being defined when i mouse over it, but i'm getting an error when the macro tries to run the function part of the code. This is the array formula that i'm trying to...
  10. S

    Use a defined array to derive a column/row of data to use MATCH function in INDEX function

    I have the following 2 arrays from A2:F7 (defined as Array1) and H2:M7 (defined as Array2) <tbody> Array1 Array2 6 7 8 9 10 60 70 80 90 100 1 A B C D E 10 1 2 3 4 5 2 F G H I J 20 6 7 8 9 10 3 K L M N O 30 11 12 13 14 15 4 P Q R S T 40 16 17 18 19 20 5 U V W X Y...
  11. D

    Setting a string variable equal to a cell

    I am trying to create a macro that will index through an array of "keywords" than I have created and search the text contained in 2 different columns for any of these keywords. I have several rows of within each column that contain text strings. I realize I have left out the rest of the code...
  12. S

    Problem copying a column from Pivot Table in same sheet

    I am trying to copy a column from pivot table into another column with unique values in same sheet.Pivot table header is in A6 to F6. That column contains Year values and there are no filters on it. While executing the below code it is showing an error like "Application Defined or Object...
  13. P

    Macro to find a variable user defined cell in a worksheet

    Hi, I have a worksheet named "ABC". In row 4 of this worksheet, each cell from G to BG is numbered from 1 onwards and each cell has a unique number. I would like to have a macro ask the user through a pop-up question box which column data should be calculated in. For example, if the user types...
  14. E

    VBA to copy a cell defined value down a colum a cell defined amount of times

    Hope the title's not too confusing. I'm trying to write a Macro that will take the value in B6 and copy it to a new sheet in cell A1 and copy it down the column based on the value in cell C6. Then do the dame for B7 /C7 and so on. I also need to add a set value into Column S for each line E.g...
  15. L

    User Defined Function help

    Hello, I have a user defined function which converts a zipcode into the state it comes from written as below: Function State(number as string) Select case number Case is = "11111" State = "Wyoming" Case is = "22222" State = "New York" Case is = "33333" State = "California" etc. what...
  16. L

    Possible to reference range established as part of different sub?

    As you may already know...I've gotten to the point where I have established 12 different ranges based on cells values. All of the cells in the ranges are in column B. So my ranges look something like this after the code (lets call it routineA) has run: Rng1 = B2, B5, B9, B50, B60 Rng2 =...
  17. L

    user defined function help

    I'm having difficulty using a UDF to pass a value in a different column based on the input. So far I have something along the lines of... Public Function ValueMe(Over As String) Select Case Over Case Is = "1st" ValueMe = Range("ActiveCell.Offset(0, 9)").Value End Select End Function But...
  18. L

    UDF if formula that contains specific word

    I have a UDF which basically accomplishes a lookup. To do that I use this code: Function name(number As String) Select Case number Case Is = "1" name = "BOB" . . . there are a bunch of cases as well. I'm not too familiar with UDFs so I am trying to figure out how to have one that does the...
  19. L

    Possible to have UDF vlookup from closed workbook?

    I'm new to UDFs, is it possible to have a UDF for a vlookup that references a closed workbook? I have: [code] Function CCLookup(Rank) CCLookup = excel.application.worksheetfunction.vlookup(Rank, 'O:\C\Templates\[UDF Lookup Sheet.xlsx]Sheet1'!R2C1:R676C5,2,false) This is not working and...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top