View Full Version : Excel Questions
- Import Text from a file direct into a variable
- Stop printing hidden pages
- formula or macro or?
- Complex Formula?
- Explaining statement
- Embedded Object's Icon Description Disappears
- Best way to get VBA data into a named range
- Saving tabs to new workbooks
- Save worksheet as and print
- Combo Box
- VBA Questions!
- 2 sheet running total calculations.
- HELP! Combo Formula - SUMPRODUCT
- copy comments
- Manual, Automatic, and semi automatic calculation
- Tracking Change
- Formatting Hyperlink Text
- Open CSV Files and paste into Sheet with same File Names
- DDE method
- Autofilter using "or" on multiple columns?
- Formulas that can be used with arrays
- Names in Excel
- Switching between workbooks
- Data Input and compile
- Question regarding Dates in Excel
- sorting based on > 3 criteria
- creating code for Range
- Finding intersecting Values
- V Lookups - finding negative values in a range?
- How To Reference Blank Cell, And Show Blank Content?
- finding the oldest date in a workbook
- finding cells for linked worksheets.
- Replace not working when there is alot of text
- Button 4 inserting Groups of Cells with predefined attribute
- New Line in VBA for LOTUS NOTES
- need help with formula, find first blank
- Dynamic pictures
- right-click with text box
- Calculating several numbers within a cell with texts
- Need help with v-lookup result
- SOLVED - Toggle button to hide/unhide rows
- Using New Collection method for make Uniq item
- Input Box (where am I going wrong)
- Vlookup Not show #N/A when empty
- Referencing cell value in SQL statement in a VBA module
- Sheet protection
- Print from macro and disable normal print
- Code help
- Removing a Button
- Auto Filter Error
- Rows and Columns
- Cell / Column formating in Pivot table report
- editing excel data using userform
- PIVOT TABLES, PERFORMING CALCULATIONS ON SPECIFIC CELLS
- Ignore code if a date is not entered
- Returning formula
- QUICKIE: Paste special time
- Designing Custom filters using VBA
- Graph object, does it have a...
- Formatting help
- MONTHLY CALENDER
- indirect function
- Help with Invoice Spreadsheet
- Adding if is met
- Code not working - please help
- count cells above excluding the header -vba
- Formula not calculating
- Unwanted Automatic date conversion.
- Macro to check for a value in external tables
- Radar chart - adding an extra data series to the y axis
- change linked cell locations when variable changes
- Conditional formatting possibility?
- Open a website using cmd button
- Lookup of MAX amount
- ALT + TAB worksheets
- Variable Range
- Open specific worksheet
- Count
- can this be done
- Budget template with drop-down pick lists
- Select Case, Select Case nest, if, elseif, an Easier way?
- Splitting data
- Sumproduct() Problem
- Displaying shapes over a userform
- taking data from horizontal to vertical
- Showing "last updated" date in a cell
- Rounding whole numbers
- Create multiple new sheets from a base (template)
- why does my code not let me do <>
- Time Saving
- Average of Weeks for the Month based on Date
- Scrolling a User Form
- Drop Down Date / Calandar
- Insert values into cells as long as there is value in other?
- clearing Values, Except zero's, Text & Formulas
- FRACTION OF THE YEAR
- Display only non blank cells in Data Validation
- Sorting into order
- COUNTIF problem
- Runnung a macro when a cell changes?
- One for the VBA Guru's
- Adjustable print areas
- get the file size to display to the user
- what is wrong with this code
- Chart questions - chart titles from cells and partial data
- Average / Standard Deviation on range containing #N/A errors
- Array formula - Single Cell vs. Multiple Cell Output
- Macro Problem - Opening Excel File From Within Macro
- Copying pasting values using macro
- Auto row height not working - but no merged cells!
- shifting formulas
- Really confused and need help with fixed cell references ple
- Check if workbook is open.
- Using Time To Run A Macro
- drop down not showing?
- VBA to pull words from sentences
- Need help with look up range
- VBA code to Copy and PS the same area in identical sheets
- Printing Multiple Excel Files - Asks me to Save every time
- Error in a loop : how to get out ?
- Numbers that net to zero
- SaveAs, but savings with cell values not functions
- cut/paste row if a cell in that row is greater => value
- Date/Time
- Immobile button ?
- Vlookup Problem
- Conditional Lookup (I think...)
- Lookup Question with a Twist
- Cell Links
- Sum values between a variable start and end date
- Formula to get the Minimum of a Product of two Columns
- Merge formula and text into one cell (or add text to report)
- Moving data from one file to another
- Copy + Paste Special -> Formulas question
- Formula error IF Statement evaluation
- Have VLOOKUP return formula rather than value
- VB Macro - Type Mismatch
- Userform Label Format Problem
- Scatter Graph question
- 1 Data Series plotted against 2 Axes
- Excel Autofilter Top Ten
- Excel template behavior in IE
- Select Case issue
- EXCEL BASED Phone List Directory
- EXCEL BASED Phone List Directory
- concatenate formula help
- changing a 32nd into a decimal.
- Two lists: Need to delete lines from List A from B
- VBA Regular Expressions
- Numbers as text? How do I convert back?
- pulling out first instance of repeated value
- VBA; Internet_Assistant (HTML.XLA)
- Using macro to select 3 cells over.
- Way to have random #s that sum to 1?
- Defining Excel spreadsheet specifications - any advice?
- APR Calculation
- Identifying and Selecting a range of cells.
- Have function return contents of specified cell
- Highlighting a cell
- Gather a workbook name before importing that same file
- Vlookup & Hlookup together
- ActiveCell.Deactivate would be nice
- VBA Help Please!
- Macro in PERSONAL.xls
- Error
- How do i execute code when the file is open
- probably too simple to post
- Workaround to the 1024 character word wrap limitation
- Variable Column with Sumproduct
- Range("A1") VS. [A1]
- GETPIVOTDATA returns #N/A after copied to new sheet
- Deleting a Column Based on a Value in VBA
- Error on creating sheets
- Error on creating sheets
- notes that can entered in cells
- Changing a cells format to display hh:mm:ss
- is this possible?
- Data Validation Error Alert not Working
- Pivot table columns
- How to create a comma delimited array?
- Error 91 when using ViewXL
- Need a random macro
- Computing the average increase
- Code
- VBA paste values
- Ensuring Formulas Fill Down
- Protect Code
- Entering times...
- Links can not be updated. Not...
- Lookup with range
- Counting after filtering?
- Time Formula
- Want Cell Contents - not Cell Value
- Excel Charting Question
- SUMIF and Dates
- to select the range of matrix and to run mmult in VBA
- User defined Functions
- line graph drops to zero
- Having formula show "Blank"
- VBA kbd shortcut works - cmdbutton doesnt
- Counting distinct members in a list...
- If formula
- Datevalue formula problem
- user defined functions store the path of the file?
- If formula to find text
- excel cells containing garbage unreadable characters
- How to disable a cell? Cross-out-thing-a-ma-bob
- Rounding decimals
- Count formula using multiple criteria
- Convert Negative Number Macro
- Fomula result
- Selecting item from userform listbox
- autofit row height of wrapped,merged cells
- find cell in column w/max length
- Working with multiple Workbooks
- No Empty Columns to separate undelines?
- Getpivotdata error in Excel 2000 but not in 2003
- Print and Save
- Looking for help with pivot tables and calculations
- Date column formatted as text
- FINDING MISSING RANGE OF NUMBERS FROM SEQUENCE
- Currency Trade Pairing/Counting
- Select first blank cell as end of a Median range - vlookup?
- URGENT HELP NEEDED - TURNING LIST FROM ONE CELL INTO
- Drop down list
- large spreadsheet makes for very slow thinking
- Pivot to spreadsheet? Is it possible?
- VBA unprotect sheet
- Block Equation Copy
- Countif and Trading Data
- matching 3 criteria including a partial string
- Combination Generator with a twist
- Function debug help [Resolved]
- Charting, INDIRECT function question
- Toggle Hide/Unhide rows small problem
- weekly update??
- Formula??
- VBA Code, refering to new worksheet created with date
- Totals or running totals across sheets
- Excel2007 Phone format macro
- Macro to copy and paste results into a window in IE
- Macro - Files Names change
- looping within double click event
- RANK IF ARRAY WITH NO DUPLICATES?
- How can I sort in terminal digit order, a widely used filing
- Highlight Cell via IF function
- Listbox question in a userform
- Locking a formula cell
- Looking up a value in a table that corresponds to a name
- Format custom menu background color
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.