View Full Version : Excel Questions
- Automatically timed excel functions
- Sound in Excel
- I don't even know how to explain this...
- Find last rather than first entry
- Eliminating multiple entries
- Multiple Userforms
- Userform
- vlookup or find change of sign??
- Cut and Paste VALUES and FORMAT (inc Merged Cells at once)
- formula
- replace a Querytable
- Pausing code while running
- Delimiting Text Files
- Importing a sheet?
- Data entry using lists
- Search/compare/filter column in one workbook w/ another work
- SumIf on a non-continuous range
- vba advanced filter
- offset to select cell
- Macro Copy/Paste Comment Box Text
- question about graphical summation
- I need a macro to help move data
- Worksheet_Calculate doesn't fire with Find/Replace
- list
- Graphing Feasible Region on Excel
- Saving
- Alternative to nested If statements
- Formula for calculating tax
- Macro to incrorporate Solver?
- ShowModal issue
- Or Function on Multiple Conditions to Prevent #DIV error
- Looping through sheet and comparing to 2nd sheet
- Macro to edit multiple formulas
- Advanced Filter with Multiple and Logic Criteria
- Fill Every other Row
- Macro to find a word and delete everything above it.
- Cache Responses
- Disable control CTRL+ALT+CANC keyboard via VBA
- Time Question
- VBA Code for a Blinking Background!
- help with if statements
- divide up 40,000 entries into smaller separate worksheets
- column auto-width
- User Form - Nudge Objects
- On adding rows
- Worksheet Protection question
- Complex dependency of one cell from another
- Advanced Filtering Macros
- Grouping columns by content/order to import to Access
- Textbox Userform
- Replacing String in Graph X Axis
- Excel 97 How to stop windows referring to macros or link
- Protected Spreadsheets, Password Prompt
- projects finished.......anyone bored???
- Searching a table for a specific value using a Query in VBA
- Application.Volatile - Has anyone used this?
- Basic Excel Division Question
- AutoFilter and Subtotal()
- Chart Data range moves with the date?
- Calling Excel Macro from Word
- Condition met = userform on opening...(?)
- Have SendMail macro to email .xls, Need to add body msg code
- count full weeks
- Generating Random Numbers - Tough One
- On adding text
- Column values in row formula
- Pie chart: show data table; label w/value AND percentage?
- Assigning a task - to my Outlook from Excel
- count lower case letters separately from upper case
- Avoid removing borders when doing a cut and paste?
- Must you activate before you select?
- Calculating number of combinations
- Conditional Formatting, or formating of Cells
- printing receipts
- Activating Open Excel Worksheet from Word
- Data from paste uses columns instead of rows.
- How to make a range dynamic?
- Tallying Changes in a Cell
- Auto Filters
- Charting : 1xColumn and 2x Line ?
- Problem Summing Textbox results
- unhiding worksheet tabs
- Make Cells Link between Sheets Include Original Cell Colour
- Macro code to save edited file as current name 2 new folder
- Separate list of rows on condition
- Control links to files that move often from directory.
- Work Book name base on display in cell
- Cells automatically populated - how does it work
- Formula for changing the format of text
- How to send data from excel to database?
- Customizing your own charts
- Security Feature? Controlled Document.
- Importing data from PDF to Excel template
- Pivot table - Subtotal
- CONDITIONAL FORMATTING
- a weird one- workbooks.opentext error
- MORE CONDITIONAL FORMATTING
- ComboBoxes on graphs
- Pivote Table Report
- Visual Basic in Excel and Access
- Manipulating Excel from Word
- Query returns " xyz ", "abc" ...can i se
- Assigning a Shortcut Key
- Line Graph data
- function vs sub
- Best way of linking data from separate workbooks ?
- Index, Match ?
- Pivot Table Count
- averageif, sumif help
- To get ceiling on same cell
- Re: Conditional Formatting, or formating of Cells
- Difficult counting!
- Saving to and retrieving from the registry
- adding rounded up numbers
- Check boxes
- In VB, How do I find.......
- Excel/Sage Connectivity
- Linking a macro to different sheets in one workbook
- Automatic generate unique reference numbers
- Automatic Unique Reference Numbers
- Auto Border Sub
- Inserting CSV file via ADO connection to SQL
- Counting occurence of text in a range of columns...
- Looping through text boxes on a user form
- IF statement: another weird one...
- Help with getting data into Excel from Unix machine
- Data Validation
- CHANGE LINKS
- Expanding selection
- it cant just be me who needs this
- Create sequential numbers while ignoring blank rows
- Format Text Box
- Activating Data Form command using button in Worksheet
- Text Boxes and Arrows Macro
- Spliting Cells
- Translator, please.....
- List box creation
- Globally defining a variable when writing VBA for User Form
- Find All Folder names
- Macro Virus Protection
- index match + lookup?
- Font Size - Default vs. Insert
- ######
- Vlookup Matches
- Calling Andrew ADO problem
- Indirect to Variable Workbooks
- automatically insert five lines between existing lines
- Undo and visual basic
- Rounding numbers created by a formula
- Adding up alternate numbers
- silly question, but here goes
- Sorting numbers
- vba control of imbedded images
- Using Excel to change colours of bars in PPT chart
- Disect a string within a TextBox
- How do I set page defaults
- workbooks
- Macro for sorting text from a terminal-style list to...
- PageSetup.Zoom and the evaluation of FALSE
- Margin defaults
- If and Statement/circular reference error
- using offset to run macro on data array??
- Index Match
- opening 2 files
- Tallying Text Responses?
- Default Opening Spreadsheet...
- billing
- First cell with value in a range
- Parsing data
- who is the graph problem solver
- Applying Special Characters
- Format All Worksheets AND Graphs (ALL TABS)
- Move a button
- Protect all sheets from a workbook
- "Smart" Numerical Data Sort
- Macro
- Using OR function with VLOOKUP
- Speed up recalc?
- count calculations
- Run-Time Error 13 an vlookups
- Help with hyperlinks
- NEW PROGRAM LAYOUT
- How to run a simple "regression" analysis in Excel
- Command button that will not go away
- VBA - How to find most recently active window?
- Macro to change colors of repeat numbers
- Calculation Question
- How to return directory path in macro
- Pivot Table Data Source Connection
- Macros
- Template Wizard with Data Tracking
- Microsoft Excel Add-In
- 2 Copies of my Excel file open automatically
- this code is looping and I can't find where...
- Looking for an odd lookup formula
- same code different workbooks
- need problem solved - dynamic charts
- Form for user entry and popup
- tricky tasks for an amateur
- circular reference
- Easy Question
- Conditional formatting in VBA - more complex
- Macro takes waaaayyy too long to run (long post)
- Lookup Function
- Hyperlink stock quote info
- graphing
- Problem with #Ref! error
- Deffective VBA CODE for sending tasks
- chart scaling anyone
- check to see if column F is equal to the sum of AF:AK
- Struggling With VLookup
- Calendar Function In Drop Down Window
- time computation
- Dealing with Error codes...
- Truncating Function
- blank values when importng
- A [b]New & Challenging[/b] Project!!!
- automating the naming of worksheets
- Macthing cells
- Need to make some rows repeat in all pages
- How to disable ??
- Can I change a column to a row?
- Sub stops after closing another workbook
- Email dilemna! Is this even possible??
- Popup Box
- message boxes in general
- Deleting invisible sheets ?
- What is wrong with this code
- E-mail notification of database updates
- links to external files
- userform clock
- Multipying a Time by a Currency Value to give a Total Value
- Select top 10 from list
- Printer dialog box
- Using Speechmarks in VB code - help required
- CONDITIONAL FORMATTING OR THE LIKE
- Seaching across ALL sheets...
- format cell
- Printout VBA ?
- Flashing boxes under conditional formats ?
- Doing Query between two sheets? Can it be done?
- Funny Sheet!!!
- Find function status
- Email question
- toolbars
- lookup
- Populating Comboboxes from Spreadsheet Range
- Sum problem in VBA
- Adding a digit in a formula
- More than 3 conditional formats needed
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.