View Full Version : Excel Questions
- Dynamic Range Refers to Current Sheet Problem
- Locating last Address of Column
- Locating last Address of Column
- In VBA - Can I connect to unix server and submit script?
- Am I Using COUNTIF Properly?
- Print selection from Excel to an .RTF file or word document
- Delete Rows that contains 0 automatically
- Formatting/Formula Macros
- Validation dependent on previous selection
- Pivot table formula for percentage?
- Adding new cells with data automatically to a column
- Global BeforeDoubleClick
- Auto filter with variables
- Need formula to sum only 12 rows but not add zero cells
- SumIf
- Date comparison
- Need formula to sum only 12 rows but not add zero cells
- Sheet protection
- A simple Pivot Table
- "One Click" to print multiple pages from multiple
- Send Lotus Notes Email Attachment
- VLOOKUP maybe??
- Data Linking and Cell Formatting
- Using Conditional Formatting to Highlight Duplicates
- version confusion
- Restrict entries in an ActiveX text box...?
- LookUP Equations
- Grey out ActiveX boxes based on earlier ActiveX entry?
- Use tab/return to go from one ActiveX box to the next?
- excel vba
- Horizontal Filter
- Copying Personal Macros
- I have run out of columns
- What do i need to do to have exact match
- Seems like simply but not working
- Min Function with 0 values in row
- Pivot Tables and very Large data Files
- Conditionally Format row
- Comparing Lists
- Conditional Cut & Paste
- VBA Paste Special Values
- informix database query question
- need more memory
- [b]Tab and other buttons not working properly![/b]
- E-mail Sent If Certain Conditions Are Met?
- Command Button Location
- Email a WS not a WB
- Repeating result with VLOOKUP
- Auto Filter or Pivot Table? (or something else??)
- modify macro
- FORMAT?
- advanced filter if statement
- Date Input Code
- Coloring stacked bar graphs
- Blue week, yellow week, blue week...
- Worksheet protection and insert rows
- lock single cell in Pivot table that autoupdates
- Worksheet Function
- Can't see my Excel file!
- Change color of cell based on value
- Coloring stacked bar graph
- Date and Carriage Return in Macro text
- creating/linking list
- count cells colored by conditional formating
- Macro Too big
- Sumproduct in VBA problems
- Logical test for a hidden column
- Chart based on Auto Filter results?
- Sigma Function Help
- Displaying cell locations in macros
- Need help with sorting/hide macro
- Automatic links from another workbook?
- Add a Check Box to a user form at run time
- Another Hide Row Macro Question... I have read several post.
- Automation: Excel, to ascii file, to bank
- Looking up both horizontally and vertically
- Validate Name Entry in a UserForm TextBox
- Two tables, one list of unique names
- Referencing Cells
- Identify in code what cell or range is selected
- getting numbers in a column
- Outstanding Days and Interest Calculation
- numeric value for aphabet texts
- Merging Cells\ Importing External Data
- How to edit a cube?
- If Statement
- Exporting comments
- copy last row from sheet2, paste to last row sheet1
- Validation trouble
- Activating Macros?
- MOVE AND CUT ROW
- Summarizing comments
- Update graphs automatically...
- Dates, Production Period and Headcount Problem
- repeating macro for different sheets
- can't open a file, help!
- Dynamic Page Breaks in excel
- max and min values in the form of Y Error bars!!
- ComboBox Problem
- Closing Explorer from Excel
- Chart Labels
- Dates / Production and Headcount problem.
- dynamic correlation
- Search & Replace Returns
- Search & Replace abbreviations
- Split columns or first and last names
- Code for Chart - Selecting XValues
- if value, then color change
- Cannot Open Workbook
- adding today's date to a phrase
- Dynamically Determine Delimited File Using VBA?
- Data from SQL
- Laying out UserForm with Code and keeping the changes.
- time stamp
- Graphing by layering columns and adding lines on other axis
- Check Sequence
- Conditional formatting based on value of different cell?
- Create Columns from rows
- Format integer as Time?
- Unix
- On open Enable Macros AND "Continue" (vs. Edit Lin
- CUMPRINC .. Breaking it out
- Next Worksheet Code Won't Work
- Find Links
- Macro Pause
- Select Multiple Worksheets, then Print using PageSetup
- Names of cells?
- Excel 97 formula won't update
- Disable code viewing
- Text Conversion Problem
- Macro to copy date from one sheet to next +1 & to the ta
- Auto run macro when file is opened
- Custom Importing of Data into a preset XLS Spreadsheet
- changing the color of the active cell
- Countif function with conditionals
- Coloring a cell...
- Help! im a retard
- Calculate f9
- generate/replace charts...?????
- Compile Error: User defined type not defined
- SpecialCells Property Error and Deleting Blank Cells
- Name format in mail list
- Getting running percentages from a pivot table!!
- Text Box Linked... now what?
- Missing Columns
- Getpivotdata wild cards?
- Conditional Counting
- How can I View a List of ALL worksheets, not just some
- Filtering
- Make Excel VBA Function
- CONCATENATE - can you combine text and numerous Alt+Enters..
- Identifying the Furthest back digit
- If function
- Querytable
- ComboBox Macro to display Name Range
- Mouse Pointers - XL97
- concatenate cells
- Counting with Multiple Criteria
- Excel 97
- Calculating Date Fields?????
- Need help with VBA barcode scanning applet
- How to get to next row
- counting with a button
- Indirect Function
- combining multiple variable ranges to create chart
- Sorting question - thank you in advance
- cell comments too small
- Excel to Word modifications
- Inserting Cells not entire row-How?
- copy column using number for column index
- Would like to magically bold some text--am I crazy?
- Insert Checkbox into Cell
- Need to find a formula to identify duplicates in two columns
- Filtering column to the left of a workbook?
- Rolling Date Filter in Pivot Tables
- Ensure User Selects Multiple Files in GetOpenFilename
- runtime error
- Worksheet Buttons
- Easy way to delete blank rows in a sheet?
- Conditional Format If Cells Contain Text
- Mulitple Criteria Sumproduct assistance
- Running Macros on protected worksheets
- depenancies and precedents (I think)
- WORKDAY function
- use lookup instead of CONCATENATE
- formula within =If() formula
- defining links for outlook
- Graphing Question
- MS Query and Dynamic Ranges
- Removing blanks from a validation list
- Excel as a front for SQL
- Please help me on 2 homework questions
- Ok, why does my worksheet have 1500 plus pages?
- Split text from one textbox to two separate textboxes!!!
- Vlookup ?
- Saving a file in a subfolder created by cell reference
- MAPI email attachments
- Power Point code
- Importing a csv file
- Clear all unlocked cells (protected sheets)
- Toolbars
- using vba to program vba???
- Automatically save
- Problems with R1C1 Reference Style
- Problem with line of syntax
- Dynamic web query - stock data - formula help?
- de-formatting category x axis interval
- Column Widths in Excel
- Referencing a sheetname from an entry in a cell
- Page setup preferences not working
- Unrequested Formatting
- if function- checking against a string
- Combobox in userform
- Number in a text string
- Subtracting DATES
- What Function to use
- $ signe for Fixed Reference
- Transferring Data from comboboxes in userforms
- Vlookup ??
- Show value in pop-up window
- Protecting formatting ? Template? Help? :help:
- How to determine when Paste has been used?
- Select Row Macro
- Functions, Macro or VBA?
- Vlookup versus Index
- Adding borders dynamically to tables
- Moving column contents down one row?
- Set Username and Password to open file...
- Macro COde to Not print sheet if Cell = 0
- Lock sheet whilst still be able to use combi box
- Macro: Turning off any filters
- taking date cells from extreme amounts of data
- IF's, AND's, and/or, OR's.
- New Entry Form
- VBA ISNA Vlookup Problem
- Run Time Error 1004 when Calling Data
- I am confused with "WITH" statement
- prevent macro from overwriting vba code in .xls file
- Print Error...I need HELP
- merging and old file to a new file
- Macro to move data around?
- Conditional Formating is not Printing!
- Excel Map
- Chart Background
- VB question for excel
- Add row where needed (In over my head at this point)
- Auto Colour shading cells
- Trying to make Print Selection Dynamic
- Hightlight duplication with different colors
- Fuctions based on control
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.