View Full Version : Excel Questions
- Is it possible to have an empty named range?
- Hyperlinks to Charts
- Referencing the name of the worksheet in a cell
- How to delete a sheet without a promt?
- Pass a value to the header/footer ??
- Counting Characters
- replace specific cell with average of group of cells
- Spreadsheets for creating a sinking fund capability
- is there a function CONTAIN
- cannot open file
- Hide ws tabs and replace a with dropdown list?
- Refresh Combo Box
- Bugging toolbar
- workbook labeling via VB
- Delphi to Excel (spelling's code)
- Quotes in formulas
- Highlight cell with maximum via Cond. Formatting
- Simple formula trouble
- comparing 2 worksheets for a diffrence in data
- tab keystroke - to move DOWN and not to the RIGHT?
- Seperate the #s from street address for sorting street names
- Auto Fill for Unique Rows
- Conditional Format
- Watch Window
- use excel as a webpage databae ??
- Can the sheet name be placed in a cell.
- Spearman's
- Excel Graphs
- Code to determine how many sheets in a workbook
- Should be Basic............
- Moving averages of different lengths.
- Another Question on Drop-Down Lists
- Another Filter Question
- Custom Function to compare 3 columns.
- Opening and closeing workbooks with VBA
- cell formula needed
- excel and BIFF
- time formula
- cell formula needed
- Select row from ComboBox populated from noncontiguous ranges
- aging categories for an a/r data file
- need help to make this continue
- Rename a text file to add date ??
- Advanced Criteria Macro...only works once!
- One sheet for Data Entry and One for Production Schedule
- Delete a macro box within a macro
- Countif to meet 2 criteria
- Loading data on date
- Compare Data
- automating macro in excel
- Charts
- Columns in Spreadsheets
- Finding #N/A
- help me im a student!
- paper clip dude
- spreadsheet help!!!
- printing
- GIF's
- Macro Looping
- Excel area graph plotting nils - and NA doesn't work!
- check boxes, some help please.
- Controlling text
- Space needed
- VBA
- Last and first day of month
- installation problems
- Generalizing the Macro Recorder's FormulaR1C1
- Locking a speadsheet from closing down
- Reducing file size
- Saving a userform as html
- VBA code for AutoFilter
- Using Index & Match to pull data from a pivot table.
- List Box
- Prevent visible macro in the macro box?
- colour in double boarder in block of cells
- Returning Info in a cell
- Express counted cells as % & change title color
- split data
- Formatting & Data Entry in Mulitiple Files
- Code to loop 'Findnext' to find all records that match?
- paste special
- Macro questions
- Move or copy... not available
- conditional average
- A challenge for people with good Macro knowledge
- Select all sheets
- Macro Added, want to remove, get rid of warning
- Can someone look at my code...
- Comparing cells that contain formulas
- countif (I think)
- Chart Help
- vlookup?
- Adding password security to a macro
- Need help creating Add-In command buttons
- Long formula in IF statement
- Set hyperlink to specific location
- Handling names
- problem opening shared spreadsheet
- More than three Conditional formats - ! ! !
- Transpose by formula
- Cell Validation (This Topic is Closed)
- SUMPRODUCT with criteria
- Shaded cells change
- Current Year / Current Month
- Setting up a simple macro. PLEASE HELP
- Changing Data in Charts
- leaving a value as is
- String Comparison
- Increasing a number based on a date!!!
- deleting blank rows after a clean...
- ListBox not "Listing"
- Sorting Challenge
- If function problems
- is it a range I am missing?
- Pivot tables
- Find closest number to zero
- The GetDirectory Function - Is there anyone familiar with it
- Creating button images programatically
- How do I add 2 years to a date field?
- Gridlines in HTML Output
- Worksheet numbering
- MANY conditional formats
- Automatically Display Comments?
- A function to return # of days in a month or range of months
- Saving worksheets in VBA-Excel
- copy from one sheet to next available row on another
- Worksheet references
- Run macro when workbook is opened
- I'm new and confused
- Rotate Info
- No extra spaces, please.
- Reverse of Text to Columns
- How to use Excel Posting utility?
- Getting data from files selecting by date
- Graphs from drop-down list boxes
- How to access the row number form $A$57
- Excel Secret # 15 but reversed from bottom to top????
- Program crashing on opening
- Is Not Blank Question
- how do I use the getfilename command in a macro?
- Hyperlink
- incorrect calculation?
- simple formula
- Rank Tasks in order
- execute a macro upon change of cell value
- How to return a row number from lookup?
- Delete row in a named range
- Can you protect one single cell.
- Re: Searching for the lowest value on a different worksheet
- MACRO Question
- two subjects: comments in macros and ranges in macros
- Ranking in Excel
- countif function with dates
- Need help disabling UserForm
- FLOOR FUNCTION & ABILITY TO LIMIT MIN RESULT
- Not Enough Memory, Combo Box
- Simple way to find duplicates
- Now/Date/Time Functions...
- Bogus cannot-update-link error message in Excel 2002?
- Deleting, Cut/Pasting, based on "IF THEN?"
- Combobox Question
- How do I print non-contiguous ranges onto one page?
- Flashing Text
- Disallow changing zoom on a form
- Excel Macro Websites
- Question related to Advanced Filtering feature - Please help
- Invoice Numbering and duplicate Printing
- Changing default Cell Comment font size
- Custom Function -FormulaInCell
- hiding rows
- Selecting Cells using Ctrl Button
- LOOKUP function
- Back up excel files with CD burner
- printing labels from an Excel database
- Open file with specific toolbar
- TAB Delimited Excel Fie
- macro to open html files as excel files
- cmdbutton for find window
- Run Macro in Excel
- Action on workbook open
- Overall pass/fail
- Select Analysis Tool Pack using VBA
- Will my English macros work on a French language PC?
- help
- Auto Refresh a File
- Text Validation
- Select date in Excel database (log)
- CAN YOU HIDE A WORKSHEET MENU BAR
- Missing Class Members
- AutoExec Hell
- Inputbox Password
- Running Macros
- Option Button Query
- Excel 97 Insert the degree symbol
- Help!! Formula references
- pivot table reference
- Weighted Average
- Excel Formula not updating
- Cursor location formula
- textbox date
- Removal of unnecessary macros
- Opening files using a macro
- file size too big... need help
- formula to calculate based on cell's conditional format
- setting the page breaks before printing
- Check for a Drive
- Open a file from a specific drive
- Remove Hyperlinks
- =LASTROW(A:A)
- Date formula help
- Integral Calculus
- Next available unused cell
- Conditional formatting, vba macro code
- combobox blues
- Naming a new workbook
- Count Items in Page Field on Pivot Table
- Clicking Data points
- Accessing file with unknown name
- A counter without Circular References?
- File opening
- lost protection on spreadsheets emailed as attachments
- Hiding #N/A
- Database query
- Assigning a macro to a text box
- Variables into a formula
- Sort ranges in pivot table
- Automatically show current date in cell
- Animations In VBA
- Macro creates page break for each cell
- File Size Reduction - Pasting from Another (Bigger) File
- Creating a Filter
- Creating a new sheet
- Viewing "Morefunc" add-in list
- Need formula to count cells with conditions
- HTML Maker
- Converting Time To Decimal
- IF, AND, OR, I may need them all..BUT...
- Easy question re: dynamic/relational formulas
- Worksheet_Activate Does Not Work after Macro Runs
- Target.Address with merged cells
- multiple sumproduct
- Filling Blanks in a column
- Easy one. How to use a keyboard character to activate macro
- Macro for copying from variable worksheet
- Time stamp
- clearing print area markers
- Can I move the Comment Box?
- Simplify formula
- Looping Macros
- Close Excel from DOS
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.