View Full Version : Excel Questions
- Sorting issue
- Need a slick answer please to a simple query
- How to declare function that returns array of dynamic size
- Web Query - Unwanted Scientific Formatting
- Vlookup Question
- Formulas
- Changing the position of the cursor after data entry.
- macro - Select All Sheets
- Word wrap to next cell
- Copy Sheets
- Exporting an Excel list to Word database
- Conditional formating
- Formatting rows when using Subtotals
- After using Drawing Tools. now can't click macro buttons? HE
- Quattro Pro
- Label on a chart question
- Macro halts on 2nd Paste command
- PLEASE HELP--Sorting one column to match entries in another
- Why won't this work? (see attached code)
- EMERGENCY!! HELP!! Excel won't let me save my file!!!
- Excel 2000...Send To feature
- Table of Contents based on worksheet names???
- Sum only positive numbers in column
- macro or conditional issue
- Look for blank cell
- Select next empty row
- Moving charts using a macro
- Insert Comments possible or no?
- Named Ranges and Arrays help!
- User logging
- Expanding Ranges of Numbers Automatically
- IF STATMENT - IS THIS POSSIBLE???
- Format a cell using vba from Access application
- AutoFill Formulas Easy one
- Need Help with Charting or statistics or something
- =ISFORMULA(A1) ?
- Basic VB Code Needed - HELP, Gurus!
- Scientific notation
- Trying to convert a Lotus 123 macro to Excel
- More than 3 conditional formats
- HELP - TO FIND AND REMOVE BITS OF TEXT
- Who can find the solution
- hlookup
- REFRESH PIVOT TABLE
- transferring hyperlinks across cells
- Printing pdf files from Excel
- Naming a Picture Element
- Including line breaks in concatination function
- Pop Up Warning Macro Message
- VB Code to select multiple named ranges
- Selecting diferent ranges
- Quickly Transpose
- leading zeros
- Transferring the Total to new worksheet by Month
- I need blank fields returned from links to blank cells
- Web query to text file instead of worksheet?
- Posting a $ sign in a textbox?
- Calculating times
- Time Keeper...
- Sum column with both - & + numbers
- ??? file
- 2 Variable Stacked Bar Graph? A Challenge!! ;-)
- Help!!! 3D scatter plot
- LisBox - UserForm
- Formula to Status Three Dates
- formulas for counting in bases other than 10
- Mailsession, MailLogon, etc?
- Stop data entry into cell with condition
- sampling without replacement
- Infinite bigness/smallness
- JOB PROSPECTS
- getting blank cells to act like empty cells in line graphs
- Opening seperate Excel worksheets with a form command button
- Inserting VBA code into macro created sheets
- VLOOKUP (a bit quirky)
- Counting the number of different values in a list
- Conditional Formatting using 2 worksheets
- Open a particular sheet
- text vs picture of text
- Coloring Cells
- Joining Pivot Tables
- ConflictResolution - Need Help URGENTLY
- Calculation
- Format multi-sheets
- Macros that can open an open menu
- Cell values in Footer
- Finding linked cells
- worksheet name
- worksheet name in cell
- Multiple criteria in FIND formula.
- Filtering values in one list based on another
- Database full message
- text > number
- Macro only running Once 2 Questions
- Create a 3D stacked graph?
- Sum top 4 scores in list of 7
- MsgBox help please
- Howdy, tricky one this....
- Validation for Data Entry ...
- Change Event on single cell
- Checking to see if a file exists
- statistics of text
- problem assigning macro to button
- Changing Value To Negative Value
- Auto Open Macro: Where did this come from?
- Adding Items To A Listbox
- Using text as a cell reference for a macro
- Applying code being used in a worksheet to the entire workbo
- Disable automatic link
- Producing warnings
- Validating a Data Entry ...
- Match?, Lookup?
- Copying from 1 cell into merged cells & keep formatting
- Validation list on separate worksheet
- String Manipulation
- Copying Formulas to numerous Worksheets
- Sheet1.Unprotect does not work in xl 97? (Sorry, I still nee
- MessageBox - simple problem
- Data validation in Excel 95
- How to split a text file into two worksheets?
- Using a value within cell as range in macro (Sorry to ask ag
- Using Auto-Refresh In Web Queries
- custom drop down lists
- Macro Buttons
- Timed combobox
- Making My Macros Stick.
- How does VBA determine the 1st visible ws?
- Look up a cells number
- removing zero values
- Workbook Open MsgBox
- Footnotes
- Summing lists that contain N/A without losing formulae
- Need help with VB code
- Closing down all open files within Excel
- Delete rows
- Chart
- Adding Rows - Macro
- Select used range
- Using cell reference but then select that cells value on ano
- VBA String Manipulation - REPOST
- Reminders
- Make the Header/Footer bold
- Input Masking
- formula question
- text in a shape
- Easy Newbie Question
- Testing for autofilter in macro.
- Using a macro on multiple files
- still looking for help on counting in different bases... can
- updating a db on worksheet_change event
- Date Formula
- Summing a range + other cell with N/A values
- Sequential Numbers
- Book 32
- How do I insert rows after each subtotal using VBA?
- Visual Basic to retrieve cell location of any number
- need to copy data from worksheet to month's worksheet - help
- super easy question for u guys, pls help me!!
- CALCULATE A SHIFT IN HOURS PAST MIDNIGHT
- Want custom toolbar to not be global
- Count shaded cells
- Listing a $ sign in a listbox?
- VLOOKUP based on 2 or 3 conditions....
- SUMIF (I Think)...Help on summing a range with different val
- pls help me, about this validation with user form.....
- another macro?
- Parsing Multiple sheets into one
- something in registry forcing update links in spreadsheet
- Checkbox background
- sumproduct
- CSE(array copying problem)
- formulas in tabs - Excell 200
- Use macro to add 1 to a cell
- Mouseover Dropdown list
- COPYING A FORMULA IN CELL
- average formula without getting div/0 error...????
- General printring question
- Sumif formula/countif
- VBA for mouseover a cell
- provide second smallest value from a range
- Macro - assign a number to number in a value, multiply then
- Macor Needed
- Macros/Formulas
- How Do I Hide A Worksheet
- Array Formula
- Evaluate for empty cell
- printing labels
- Linking, templates or other - Project Due By 4-11-02
- neverending loop
- Formula Help Last One Please!!
- repeat discounting X amount of times
- trying to use data in textboxes for calculations
- breaking up 1 Long column into multiple short ones
- reverse & inverse text: pot ot mottob morf...esrever ot detr
- Finding and removing links
- Non-adjacent cells
- commenting a chunk of code in VBA
- Links
- Sumproduct
- Auto updating across multiple worksheets
- Hiding unused rows
- Pivot table
- Print Orientation won't change
- comment box flags VBA
- Arrow Keys Disabled
- Genrating a quick list
- Macro 2 change another macro. Possible?
- Writing a conditional formula
- Stuck on CountIF problem
- What's wrong with my code?
- Selectively Displaying a Data Series on a Chart
- SQLExecQuery help
- List boxes
- Driving around cells whilst in a macro
- Validate cell range
- How to identify todays day, not date?
- Paste Special Data as picture from Excel to Word/Powerpoint
- Cut and Paste with Formatting?
- 2 questions - one about dates, the other time
- Creating a code for last day of the week worked??
- List Box
- Establish start date based upon due date
- Best approach to make multiple reports from database?
- Find command causes excel to crash/close the spreadsheet
- VBA ? - How to move a chart or shape based on a cell referen
- Locking hidden rows
- No Help on this one? Thanks Jay! Exactly what I needed...
- Multiple sumifs?
- Multi mail merges to word from the same workbook
- Nested Ifs
- Macro slow opening a file
- BeforeSave event problem
- Color property doesn't set ANY color
- Dave H.? Disabling Commandbar buttons/controls via VBA?
- Menu in UserForms?
- font in comments
- Type Mismatch
- ??? Userform and Macro code should work but it doesnt
- msgbox list
- Conditional sum gives a (runtime) FormulaArray error
- Making graphs with macros on different worksheets
- Help with school project please
- printing backrounds
- Userform and execution of macro
- a macro that checks if there is a value in a cell
- Too many sheets created slows things down
- A few cells with 3 digits, I want 4 digits: 345 -> 0345
- Proper code for Pasting Values
- Compile Error - Can't find project or libraries
- On double tab click goto tabindex 10
vBulletin® v3.8.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.