View Full Version : Excel Questions
- the cells just keep expanding
- Text to columns
- Data copy based on selection
- Formatting an email
- One Question
- How to remove numbers
- Chk valus in 3 cols if lengh of charecter is met or move to next sheet
- Macro to have 1 activeXButton instead of 48 activeXButtons
- Copy formulas, but skipping cells
- Pivot table averages...
- Help with VBA - Sort data based on column listed in cell
- Auto Refresh on a NOW() formula
- Creating a list of names through scores
- text to numbers
- Time format
- Copy Custom Number Format
- Formula too long! Summing 16 workbooks
- Excel importing data from Access
- Chart in existing worksheet
- Quote characters appearing in VBA code
- Creating charts with VBA
- Deleting keys from a collection?
- Problems with running Clock in worksheet cell
- Can't figure out removal of #N/A using ISERROR
- Macro help in removing Char(160, 34 etc)
- SUMIFS criteria - referring to other cells
- Find and replace for Hyperlinks?
- Open Event Issue
- Macro help with solution
- How to make the macros keep working even if the sheet is moved or mailed to another user
- Help with formula for Subtotal (3, . . .
- VBA how to rebuild index for ADODB connection with dBASE
- From a Pivot create a Flat File
- Identify Active Cell Range
- Vlookup and Duplicates
- Returning Cell Reference
- Set Cell value in a different workbook opened with VB
- Named ranges - why do have to keep confirming location?
- Use address of a named range in a compare statement
- Removing spaces from Text
- Macro instead of lookup
- Can I change some VBA code from other Visual basic program?
- Novice array question..
- Cells.Formula = Long forumla
- Pointing to a cell and searching a row deleting values the same as cell pointed to
- Select Macro depending on List Value
- Capacity analysis
- Ranking Issue with a Matrix of Data
- Building a table in VB
- Auto-Print Macro
- CSE or 3D sum
- Unable to open excel2003 file in Apple computer
- To incorporate moving text..
- Calculating hrs which are input in 0":"00 custom format
- sumif / lookup - many entries in column.
- Copy/paste/add sheet
- Look, Find, Grab, Insert, Sort, and Print
- Data Sorting
- getting into macro
- Help
- Conditional formatting (Excel 2003)-multiple choice
- Macro to change all cell formulas at once
- Paired Chart Automation Macro
- Summing every other column
- conditional sum or sumif
- =WORKDAY(RC[-1]-1) -- Excel 2007 compatibility
- Execution based on User
- IF Formula Help!
- on error always running. even when it works
- Copying values between symbols to (different) cells
- Prevent scrolling past last cell?
- query foxpro in excel 2007
- Hiding Columns
- Add a help button to UserForm
- Macro/Formula based on variables
- Copy and Paste Values
- Multiple Criterea
- Help with cell format
- IF statement returns #value - I think I have an error?
- Search a ID Number in VBA HEEEEELP!!!
- Outline function in Excel (Data from MS Project)
- Auto-Check Macro
- Sum if formula using "left" or "find" for range
- I need to copy data from a column in one workbook to another...
- modify Goto Rng macro
- Display latest entered data along a row
- Format text cell with unlimited text
- Pivot Table Updates - VBA
- Staggered Dates Help
- Quick Question- Countif Arguments
- Copy and paste graphics
- .find with date having problems
- Averaging accross cells (ignoring blank ones)
- Using a percentage weighting to create an averae score
- Sumproduct problem
- Option Prompt VBA
- New Question
- Cell format won't change
- Variable Builder
- Excel 2007 Page Number Question
- Code doesn't work in standard module
- Conditional cell locking based on font color
- Max Date Formula?
- Add a scroll bar/spin button to spreadsheet
- Format a single list into multiple lists
- List unique cells
- Pivot Calculated Field based on 3 values
- SUMIF data with variable file name possible?
- Syntax Error
- Colour identicall cells in two columns
- help cleaning a macro, +hangup with paste special
- Remove legend entries in a chart
- Missing Text from my page footer
- Activate Macro's when condition is met
- Insert Excel Worksheet into Database - Cleanup
- For Loop copy and paste
- If then else statements with date range
- Calculating averages
- Spin Button
- Conditional Formatting Dates in Excel 2003
- :cool:Team Leaders
- Workbook Calculation
- vlook up or something like that
- My UDF
- Importing Data to Excel without using TXT file
- Cell Address Problem with Modeless
- Moving modules in VBA
- Date to Date Calculation
- Tricky =Find() in Text
- Linking All Applicable Data To Defined Range From One Worksheet to Another
- xaxis incorrect in chart created with VBA
- If statement problem
- auto open all links on a webpage?
- Excel Database (times & dates) as Mail Merge Source
- Identifying gaps in a timeline
- Import many csv files into one worksheet - select special folder
- Range()
- Close Active workbook
- Reference sheets not yet created
- Countif question
- VBA code to change the print setup
- Searching cells for text
- Sumproduct with Timeline division
- Issues with Looping
- Query from 2 DSN's into a single table?
- Transparent Text Quality
- Clearing Multiple Checkboxes with VBA
- Macro for two conditions
- Open Dialog box
- Button to change date? +1 or -1
- MS Flex Grid
- Problem with INDEX & MATCH
- Excel array question
- Array in VBA
- VB Formula Value
- How to sort horizontally for many rows
- Formula changes based on cell value
- Finding lowest values in a range
- macro for pie charts
- Dropdowns using vlookup reference
- Change PART of formula using "Find-Replace All"
- conditionally format a future date
- Create loops
- assigning Conditional Formating with VBA
- Long If iserror/if formula problems
- Index from multiple sheets
- Extracting time only from date
- Excel solution reqd. for a practical scenario in retail industry
- Help with a Formula
- VBA - Determine last row, use in loop...
- Could not load an object because it is not available on this machine
- Condensing a Data Set
- Flashing Text
- Update multiple sheets using multi select Listbox
- Create Message Box
- Pivot Table As An Alternative?
- Help about Auto fill data in IE and return the result into Excel
- Is there a EOWEEK?
- "=+"
- Conditinal Format - Comparing 2 areas VBA
- Is there a way to AutoFit Row height on a merged cell
- Data Validation - Custom problem
- Delete Items Duplicate leaving Cheapest (Macro)
- Variable column in a VBA code
- Counting the number of januaries between two dates
- Lookup, sumproduct?
- Date/time data lookup
- Deleting Entire Rows above and below a specific range
- Date
- Stock price history - multiple stocks
- What happened to ALT-TAB?
- VBA auto click ok on pop up box
- Stacked Area Graph - 'Plot Empty Cells as Interpolated'
- Listbox Click question
- IF command or VLookup?
- Else without If error
- Case statement question
- Registry Cleaner
- Using the TAB key on the keyboard to move to another cell
- Modify Code
- 2 Workbooks - Without opening the 2nd
- Pasting Data from different Worksheets
- Help with code
- Extract cell formating
- Help with code
- impressed with the help
- Dealing with text duplicates in Array formulas
- Question about IF Statement
- Formula to Evaluate Axis Max/Min
- Capture the "F1" key specific to a Textbox ?
- Button Help
- Formula to give me the top 5 person in my list
- Remove flashing cursor in VBA Module
- Add together Values in Coloured Cells
- 2007 before save event, changing fileformat
- Find string of numbers in a sentence
- Stop the prompt
- 2 in a row copy and paste macro problem
- Count
- continually moving text..
- to find maximum number of letters
- Userform Query
- Sum if
- Copy & Paste row data macro
- Three way matrix lookup help...
- Search and Select macro
- How to shade/colour rows using VBA based on cell values
- Lookup function .... I think...
- How do I get rid of excess cells in a document?
- Using vlookup, finding lookup value in more than one sheet or one workbook
- Combo box to populate cells
- % Match
- Making respondents rank options in a order for a survey
- Max rows macro
- Trigger a Macro In Word 2007 via Excel
- How to remove multiple hyperlinks
- Adding a vertical line on secondary axis in barchart.
- Progress Bar...
- Multiple look ups
- Split value in cell
- Collumn width and row height
- Excel Macro to print multiple worksheets to ONE PDF file
- VBA Sorting
- Incorporating a cell reference in a sum formula
- Advanced macro help needed ASAP
- Mimicking Google's Pagerank
- Print macro for shapes sheet
- deleting repeated values.
- Tricky Puzzle
- Hide/Show all open userforms
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.