View Full Version : Excel Questions
- How do I poulate Userform text boxes from a sheet of data?
- if, lookup, transpose? not sure...
- Reference cell in another workbook using cell value for part of workbook name
- Finding Thunderball Matches
- Fill Effects in a single cell - 2003
- VBA for each loops
- Determine Previous column
- Creating auto PDF
- If statement with a vlookup
- Executing a macro whith click over a button and ctrl key
- Excel crashing on opening workbook - what to do?
- is there a way to correct a word and automatically have excel correct all the formulas linked to that cell?
- Creating dynamic named renges
- Referencing a range in another worksheet.
- Excel Chart Data Selection
- VBA Set DisplayPageBreaks to False for all worksheets
- Auto Filter VBA help?
- Duplicate Existing Worksheet and Name Tab
- VBA to perform Save As, delete old data, and display new file
- Deleting Filter Items
- Where to save some code...
- Question
- EXCEL idiot
- copy data from txt file to excel sheet
- Increment paste filled in data repeated
- AppActivate and Excel 2010
- is it looup or what
- macro > protect sheet settings
- Comparing Data, Copy & Paste Unique Values
- Move data from sheet based on value in one row
- Question regarding 1065 and Excel
- Count a cell based on colour of the cell
- Conditonal Format with quarter and year
- Excel Opens Small
- Runtime error with "do...until"loop
- How to determine average time between phone calls
- How to add a line to "lock picture aspect ratio"
- Search Cell contains formula and Numeric value
- Replace specific character in specific position
- lock conditional formatting?
- Change ActiveCell based on ComboBox Selection
- A dropdown list from another dropdown list
- VBA parameter query syntax error
- Return First Blank Cell in Range
- General question about references
- When adding new columns, is it possible to delete older ones?
- Problem with conditional formatting dates
- simple CrLf
- Event Change Question
- Unable to change page layout
- Macro not working, trying to make sheets "VeryHidden"
- Variables with ActiveCell.FormulaR1C1
- Aligning Cells with the same time
- image capture coding
- Need to know how to display specific character range in a cell
- Photo to text
- Mailing list formula problem
- Create table by querying other table
- Replace $ values in an Excel doc
- Sum a range of cells without blanks
- Class Event CutCopyMode help
- issue attaching doc to lotus email via VBA
- Can't get macro to run on a protected XL2003 Sheet
- Saving Excel workbook to a text file
- Changing from annual to quarterly data
- Remove rows
- Macro Remove Characters From String
- Why Are These Not The Same
- VBA to turn on AutoFilter even if already on
- Issues compiling data
- Setting an Option Button value to true (select it).
- Additional Question in Macro?
- Convert cell contents from millimeters to inches
- ActiveCell.Formula If Statement
- Need to Reference a sequence of data on one sheet in another sheet but with 3 rows in between each value
- XML and Connection issue
- Complex Problem
- Creating Folder and Saving in that folder
- Custom Cell Formatting
- Formula to find changed value
- PowerPivot Calculation
- Monthly Sales Analysis Chart
- Column Chart
- VBA Copying
- using variable across workbooks
- Excel Formatting
- Set Printarea in Macro
- Remove missing references VBA
- Auto Loading Macro file
- VBA Help Adding Columns together by column header.
- Fill handle not working for cell references
- Dublicate
- How to make combobox and Textbox join together for application.match
- Need Help with code
- HELP my function is acting weird
- SUMPRODUCT for dates and times
- Macro Help for Autofilter
- macros for a web page
- Algorithm Question
- Dynamic Print Range
- Need Help with this macro
- Question on automatic access to a website with a popup login
- Count where a column heading is located.
- Using a variable to accept array formula??
- Count if question
- Not able to delete worksheet after adding it earlier
- Simple bar charts in excel and adding or removing data series
- If Then Image Control
- RunTime Error 1004 for Copy to New Workbook
- Active cell = visible cells
- A "Matching" Macro
- Speed up calculation using Macros
- Help with an array formula (Dynamic List)
- Locating 1st transaction date in a table
- CSE formula with index/match
- Cell Visibility Properties
- Populating a Multidimensional Array of Unknown Size
- Code to delete rows?
- Is(error) or iferror
- Lock certain columns in multiple worksheets
- User form Data (ComboBox) to specific cells
- copy records, apply formating, delete rows
- Formatting text in word from excel
- VBA - is there a way to clean up this code?
- Returning multiple values for one lookup
- Pulling my hair out on this macro
- CountIf Function
- Creating New Tabs based on a Template and a List
- error handeling
- Trying to add values from cells with a related name in the adjoining cell.
- What is a good system to teach myself visual basic?
- Adding and removing Checkboxes using VBA
- Concatenate, but remove duplicates
- pick3
- separate two line cells to one line rows
- VBA String Reference A Double Variable
- Dates! Dates! Dates!!!
- pick3
- Need help populating a table of dates & times
- help!!
- Ceiling & Floor function with constraints
- index & match & lookup
- Please help: Selecting min time based on a specified date
- 2007 vs 2003
- Allow user to edit formula
- move column data to different row
- Using VBA to execute Scenarios Based On Combo Box Selection on an Inactive Worksheet
- Match VLookup
- Greater Than in an IF(AND forumula
- Need to optimize VBA code using array formula
- Pick up in the middle of a macro
- User form not to throw a Message Box if is not completely filled out
- controlling cell entries
- Index/Match function help!
- hyperlink to button
- Variable for "nspace"..." "; " "; " "..
- Complicated search
- Conditional Formatting
- Match multiple cells
- Paginating Copies of a Worksheet
- Formula help
- Need VBA Coding to Copy Named Ranges into another workbook.
- Please make my day
- Why my spreadsheet is too slow and heavy?
- VBA help
- Question about CSV files
- Copy range of data from one workbook to another
- macro code for select all
- Increasing the font size in pull down list
- external data connection locked the external workbook
- Array value in one cell?
- separate text from number
- Formula to calculate hours work to determine if I need to hire more staff
- lateness calculation
- Userform find function?
- Make return key in a textbox act as return key in ms word
- Removing charecters in a cell
- Macro Select Issue
- ByVal v ByRef
- Loop fails
- array to select & delete columns
- Macro runs using F8 but Open method fails when using keyboard shortcut
- insert a value or text in a desired cell with 2 columns of data that meet 2 criteria to return the info contained in the desired cell.
- Copying row equal to amount entered in cell
- If condition
- Fill in holiday dairy using userform using dates
- Help with Pivot VBA Function.
- Ranked items - Vlookup with Dupes
- How to create to the power(superscript)
- Prevent the process of entering by code
- VBA - setting autofilter options
- HLOOKUP with multiple variables
- VBA openCopyandClose
- MsgBox to Confirm Change
- Macro Sort Columns by Row
- Waht Formula To Use To Show Content Of A Cell - First Line ONLY?
- Convert lbs to stones and lbs
- Creating Sports Standings (formulas needed)
- VBA Select a Variable Range of Cells
- VBA- FileDialog Named range
- Cannot Insert Column with VBA
- Sumifs 2007 to 2003 Conversion Help Please
- xml and complicated cell formulas
- Script - 2nd set of eyes
- Hyperlink Question?
- Sumproduct Returns #NAME?
- Can this macro be shortened
- hex() function corrupted excel file
- Opening Multiple CSV files and Parsing for Specific keywords
- Simple check box macros
- Looking for some direction and or tips
- Updating links when opening workbook
- Need help with Application.Evaluate
- Move column in Excel 2007, extremely slow HELP!
- Tracking hours with multiple calculations for various time spans
- Vlookup Query
- Handling Time between two Dates - Varying day-offs
- Formula for monthly cash flow projection based on billing date and value
- Who is the biggest suuplier ?
- help in VBA Coding
- Round!
- Increase a cell value by 1 in multiple embedded workbooks
- #REF errors in Table Mode when have arrays
- Type 16 digit number in Excell...but last digit converts into 0..need help
- Automatically recalc Pivot Table
- Show Report Filter Pages (for more than 1 pivot table)
- Need Formula For Rank
- add ListBox I created to a ribbon
- Writing to empty cells in a range?
- Comparing cells question
- vba macro to punctuate addresses
- VBA code very difficult to understand Help needed
- Looping through selected Rows
- A formula to pick no from a sentence
- Excel VBA: Dynamic range for ComboBox.Rowsource values not displayed when userForm called from CommandButton
- VBA To Update Every Sheet in Workbook
- Exact function - regarding
- Disable paste - ribbon + backward compatibility
- Question about Count Distinct
- Progress Bar
- excel2003 validation...
- Constant with range value
- filling column with varying data
- Substitute Formula for 18 Characters?
- Create new dates every 3 weeks
- Insert Table Data in Comment
- Naming a range using a macro
- macro not working on multiple computers
- Subroutine and function!! help!!!
- if function in VBA
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.