View Full Version : Excel Questions
- Macro to select A1 on all worksheets in workbook
- Difference in dates in months
- Validation in a user form
- Marco to add sheets to workbook
- Macro works in one page, not when referenced from another?
- Open Wookbook
- Removing Duplicate Entries
- Additing lines as needed on chart.
- running macro on a different workbook
- Copying Formula - going wrong
- References to other worksheets and other workbooks.
- Name Generating Macro
- Variable cell reference to a closed workbook
- Evaluating spreadsheet cells automatically
- Questions On If Statements Involving Dates
- Query Manager
- WEB Query - Tabs do not work
- Lookup functionality within macro help required
- VBA Copying down a range
- Convert mm/dd/yyyy to only mm/yyyy?
- Cell comments
- Open Excel files automatically
- Past nextrow different workbook
- protect a few Excell cells
- Calculate duration of time
- Weeknum and if-the
- Formula to miss out weekends
- Getting Excel Formula to work in Visual Studio Tools for Off
- Workbook protection with macro's
- Emailing from Excel
- Automatically hiding rows with 0 in cell
- Links changing
- Print all options from a drop down menu
- Prevent Cell Editing
- inability to fill cells with color using Fill Color command
- Daily Reporting system
- Conditional Subtotaling
- text box on excel sheet
- [b]Formula for running check register [/b]
- Embedding a ComboBox in a Worksheet and populating it
- Equal values on spreadsheet but not in vba
- Concatenating a range of cells (in one column) using VBA
- Can this be done with a formula?
- linking Cells based on CONCATENATED values
- Help with formula?
- summing sheets based on a criteria
- Macro to clear all row fields in pivot table
- Reuters PowerPlus
- Open File in VBA
- PRIVATE SUB to increase Number Count by one (1)
- Using CountA in Macros
- Hiding Rows using +/-
- Email from excel on condition
- Long (200 digital) Numerical Input
- help with now function
- Importing a TXT File into Excel
- say "yes" to save the data on the clipboard for fu
- Get name of Named Range
- VBA, Workbooks and Macro Variables
- Conditional Formatting - more than 3 conditions
- null values in an if statement
- D/l pivot file, appears incorrect. Any option be turned on?
- Pivot table macro
- Can the GrandTotal be used?
- ClearContents on dropdown selection change
- Search a cell containing "AAAA"
- Search a cell containing "AAAA (1)"
- Find data in table
- Type Mismatch Error
- If date = today highlight!
- Update todays date on change
- Little Stuck
- Can you split part of a cell's contents into seperate cells?
- Embedding Question?
- Worksheet will delete from userform...Why?
- Compile error caused by UCase
- Check my Code? Date in column if changes to row are made.
- How to make a Shape Creating Demo
- Pivot Tables....perhaps?
- Change existing 1.234 to 1.234%, not 123.4%
- copying a range of cells based off user input
- Copy down formula only where Column A is a specific #
- Conditional Formatting Copy and Pasting with increments.
- If greater than 4 move one up!
- Insert a Row
- Sorting many columns, but not sorting top 7 rows
- combo box
- Filling in Blank Cells
- Return values exceeding a given number
- Match and then Sort Excel Rows
- Trying to delete rows based on cell value = 0
- Help with formula
- Where the code should go. Loading a ComboBox
- surface chart
- Conditional Formating - adjusting the rules non-manually
- Problem with Find code
- Track if a VB variable change value
- Errorhandling Question
- text to column?
- Changing "Custom h:mm" to Text or General converts
- Duplicate numbers
- Create new workbook if workbook of that name does not exist
- Web Query results VBA
- Help please
- Regression Linear Trend Analysis &Associative Forecast
- Macro to automate some time consuming sheet modifications...
- Hlookup Help
- DISPLAYING APOSTROPHES
- Help with macros that colors rows
- Header question
- Inequality shading on graphs
- Need help writing a IF formula for EXCEL ???
- Change Date to General format
- Stationary Fill Down
- Drop down pick, and then another
- Copying Sheets and Named Ranges - VBA
- Macro to close a file if open... open it if closed...
- VBA to create spreadsheet with unique name ....
- I need a VLOOKUP type of search in VBA
- Formula for Worksheet Name?
- Copy Cell a number of times
- Macro Help - Replace Bold with Regular Border
- Comparing cells from 2 Data Ranges
- compare data between two columns and output
- Formula for referencing another sheet in Workbook.
- submit on Internet Explorer Form
- programing enter key movement
- dating a column?
- How do I have macro delete a shape?
- Simplify SUMIF with multiple sheets
- Detecting a Key Stroke and Exiting a Loop
- X-Axis Labels
- Displaying Currency in a text box
- Referring to a partial sheet name in VBA
- Making Column Titles appear in all printed pages - macro
- data in a cell is numerical or chararcters
- moving data from one sheet to another
- Counting Parts of Text
- Deleting a shape with a macro
- Charting ~ Can this be done?
- Pivot Table Formula Data from previous column.
- Vertical Page break macro problems
- Matrix Plot using excel
- Highlighting a row.
- Is there a way it filter out non-numbers within a cell?
- how to use the drop down list
- Macro to print a worksheet from a print button
- Filtering Data
- Pivot table - counting row items
- Referencing cells that array covers
- Pivot Table calculated item issue
- HELP : Merging contents of two cells.
- regarding... asigning a macro to an autoshape
- Formula to find first date of a month
- Use ADO to read CSV in, but some data missed
- Run time error 1004
- Making email addresss active in Excel
- Copying chart legend outside chart area
- please help me interpret this code?
- Does windows handles the scenario when excel might exceed it
- problem with print data in the all column
- View rows between these two dates...
- change dates to dd/mm/yyyy format
- Change the colour of a commanbutton with mouse hover
- Order list box
- EXTERNAL APPLICATION PRINT SCREEN PICTURES TO EXCEL (SOLVED)
- VBA code help
- Problem with today()
- Column and Row
- Stop Clock Problem!!
- Application.Save = False ???
- Finding sum of non-adjacent cells..
- Format
- cell change
- Listing Worksheet names
- WHERE clause to access more than one cell and range in Excel
- run a macro on pivot refresh
- Head Spinner.. Multi Tasking
- Loop to copy?
- List
- cell change
- Auto hide Task bar
- Textbox on Chart
- Disply progress after ScreenUpdating=False
- ELSE IF Formula?
- Stop a formula updating itself
- Randomizing
- Nested If formula Help
- Nested If formula Help
- Small problem with email as HTML code
- Returning Particular Data
- pictures
- novelty dialog box animation while calculat running?
- Year in VB...
- Macro running in infinite loop
- Getting dates into line
- linking - copying across every 7th cell
- Refreshing SQL database queries?
- Excel Queries with parameters and subqueries
- Displaying a chart, but removing 0 values
- Simple Conditional Formatting Question?
- Graph help
- Hyperlinks to secure web pages + Firefox
- Textbox onto a Worksheet
- Form - Code
- Linking Text in Excel, getting numbers instead
- Printing a sheet onto one page
- formatting question
- Clever bit of String selection needed
- ok, now a real Excel / SQL question
- displayalerts question
- Selecting different rows across multiple worksheets
- Charts, VBA and loops question
- "End if without block If" - What does that mean?
- vlookup help
- my code was working fine until i protected the sheet!!!!!!!!
- hyper link Access record in Excel
- Outlook warning when using send mail
- Formula required
- html Editable?
- Trigger event to copy info from one worksheet to another
- UDF stops working after closing worksheet - EXCEL SP1
- Address List
- Not Case sensitive
- Is there a way to remove unprintable characters with VBA?
- Debug Errors when opening Spreadsheet from the Web
- from Excel to Transformer
- New Excel user : External reference for data validation?
- Retrieving filenames and placing them into cells
- Sum every other cell in a row
- "Compile error: Case without Select Case" - Confu
- Macro Code
- Find if there is any data or formulae
- Enter static Date with protected worksheet.
- I used ActiveWorkbook.Save in the code but it does not save
- Symetrical How do I copy & paste formulas from left to r
- Criteria for DGET
- Changing hh:mm into mm and then using num in a formula?
- Is this simple statement correct?? Please help
- Embedded formulas
- Mask for Data entry
- Speadsheet Consolidation Macro
- Determine String / Cell value length?
- ms query creating new column
- Help with Textbox Code for displaying Real Time
- enable/Disable, Hide/Unhide
- Excel formula using Access feed
- Custom Number Format for ZIP Codes
- vlookup
- Copying all spreadsheet in a workbook to one sheet
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.