defined name ranges

  1. tlc53

    VBA - Format Rows containing word 'Total'

    Hi, I'm using the function Subtotal on my Defined Name range. I would like to format the totals that come through, so that they stand out from the rest of the data. I would like to do this without necessary referring to exact rows/cells, so that the format will work even if the data changes. My...
  2. tycasey17

    Counting Using Defined Names

    I am wanting to count the number of personnel within a defined name. I have tried using =COUNTIF(A1:A5,_OFF) "_OFF" is the defined name having various titles in them. The overall outcome of the formula I am needing help with is to show there are 4 doctors of the entire range using the _OFF...
  3. D

    How can I dynamically change the range (applies to) for a conditional format

    I want to use a conditional format to add 'Data Bars' to a portion of a table column. I created a formula with OFFSET() to set the correct range and gave the OFFSET formula a defined name. When I use the name in the Applies to field for the conditional format, it gets changed to an absolute...
  4. C

    Update cell of filtered column header selection

    Good day all, I would very much like to have a certain cell reference(A4) be updated with the team leader I select on the header filters. Reason being, I have to print out the whole team for every team leader, and have the leader's name on top of the list. I have a database with staff members...
  5. A

    Macro not changing Pivot Table dates correctly

    This macro was written to change the date in two pivot tables whenever a date is changed in a dropdown box. The date is a defined name range called "DteSelect." The two Pivot Tables and the Dropdown box are in the same sheet 'Dashboard.' The data is located in other sheets. When the date is...
  6. B

    Automatically assign Defined Names Based on Another Cell.

    <tbody> John 1 John 2 Mark 1 Mark 2 Bill 1 Bill 2 </tbody> I'm looking to be able to assign all the John's to a John defined name automatically. I know how to automatically "create from selection" and use the left row but I want all the John's to have the same defined name and all...
  7. L

    Display Pivot Table Based on Defined Name List

    Hello - I have a worksheet where I have a drop down list and 6 names to pick from (we'll name this worksheet "Selection"). Additionally, I have 6 other worksheets, each containing one pivot table that belongs to one of the 6 names on my drop down list. I would like to pick any of the 6 names...
  8. ACUMEN

    Macro to print nominated worksheets with range part defined

    If anyone can help that would be excellent. My issue is i have a workbok with 12 sheets and 7 of the sheets are results of existing macros. I want to print the results of the 7 returned sheets but only up to column O on each sheet. Each worksheet runs from A-AD but i only want to print A-O...
  9. J

    Is there way to refer to a Named/Defined range within a macro?

    I have created a number of worksheets that have defined names e.g. a named range called ASX with the following formula... =ASX!$A$1:INDEX(ASX!$AE:$AE,COUNTA(ASX!$AE:$AE),1) Is there a way to refer to this range within a macro so that I can copy the range and paste it into a new workbook? Many...
  10. J

    VBA defined name help

    Hi i'm pretty new to vba and having real trouble with what should be a simple code. I have the following vba code which works fine Sub printlist() If UCase(Range("T6").Value) = "1" Then Call stocksheetsub If UCase(Range("T6").Value) = "2" Then Call supplier2sub End Sub However instead...
  11. U

    Deleting Names from a Different Workbook

    Hi guys, Having some trouble deleting defined names from my workbook which were actually created in an entirely different project! 1) How the hell did they even get in there (pretty sure the workbooks weren't open at the same time)? 2) Why can I not delete them - the delete button is greyed...
  12. P

    Dynamic Named Ranges do not show up in the "Name Box"

    I just created a Dynamic Defined Named Range following this references: http://www.ozgrid.com/Excel/DynamicRanges.htm http://support.microsoft.com/kb/830287 It works perfectly, except for the fact that the Named Range is not appearing in the "Name Box". The curious thing is that the named...
  13. D

    Named Ranges 2003/2007

    I have a 2003 worksheet with Defined Name Ranges. If I run it in 2007, do I have to re-create them? The Named Ranges seem to have been lost when I run 2007. Can it be easily converted?

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top