View Full Version : Excel Help
- Getting around Pivot Table 256 Col Limitation
- Connections in MS Excel 2007
- Solved: Delete function failing
- A complex IF formula
- Sleeper: Date Dif function
- Solved: Best way to select these ranges w/ macro?
- Trim not working and moving through a range
- refreshing data in excel
- Check or selected rows in array?
- Date Stamping a Cell Modification
- Treeview Losing Checked Checkboxes
- Search certain column in all worksheets and paste rows to seperate worksheet.
- Excel macros (if statements etc) how?
- Worksheet activate code in Add-in
- Rolling Reference number
- Solved: What's wrong with this function?
- Solved: Userform and data validation
- Want a Userform
- Transposition and rearrangement of data using VBA
- CommandButton &i.Elabled = False
- Number format to dispaly on a label from text box
- Excel VBA Copy & Paste
- CODE CANT BE WORK
- Solved: Macro to warning user of duplicate entry
- Solved: Automate msgbox cancel
- Solved: problem with a conditional average
- Solved: incorporating condition or math into sumproduct
- Solved: Select item in list if only one exists
- Activate range on a different sheet
- Copy or link data between sheets
- Solved: Find/Replace in One Column over Entire Workbook
- Benefit of making sheet object rather than directly manipulating sheet
- Solved: Treeview nodes
- Solved: 2 formulas required - Part 1
- Solved: 2 formulas required - Part 2
- monte carlo output: statistics in Excel (How?)
- conditional formula
- Solved: change formula
- txtboxes and cells. Updating editing userform
- understanding arrays
- Solved: List File Names
- Solved: subtract two formula
- Using another source
- formatting vba to work on a protected sheet.
- selecting last row / cell
- Solved: Help speed up this code (2 FOR loops seem to be the problem)
- Solved: Finding Information in one spreadsheet to populate another spreadsheet
- test if Excel 2007 is in Compatibility Mode
- Form TxtBox
- Loop to extract data
- 1024 character limit help
- Solved: Need help creating macro to insert col
- Solved: [Excel] Open files listed in varialble, extract data
- Solved: Format trend line dialog box
- Solved: VBA for sorting column with formulas
- UserForm control for a background process
- Solved: linking text data between sheets
- Assistance with formula arrangement
- User Form Help
- Solved: Assigning a date variable for use in a file extension
- Solved: Create Multiple Text Files From Cells & Save As Name In Adjacent Cell
- Breaking numbers and letters
- Passing Objects: ByRef / ByVal
- code help (newbie)
- Solved: Transpose Horiz Values to Vertical
- Solved: Make textbox visable or not visable on Userform
- Solved: Problem with my delete loop
- Stop / Pause a Macro using Pause button
- problem with preventing "" spreading all over the Spreadsheet
- Solved: sheet history before save
- Solved: Help with calling out another sub within a sub
- Solved: Toggling Display gridlines:
- copy range from different sheets
- Solved: looping backwards using steps
- What routine to use?
- multiple e-mail addresses in SendTo,Notes client
- copy and paste active cell down a column
- For Each loop: exits too early
- Task Scheduler via COM
- Solved: Allowing macro beetwen 4 - 5 PM
- Solved: CustomList Index
- Listbox Additem + ListFillRange
- excel data manipulation and sorting
- Copy Extenal workbook help
- Solved: Problem with Typename for Multipage/Page in recursive function
- View Excel Charts from Forms
- Need Help with the Easist Question Ever
- Maybe a Null question?
- Worksheet Cell Calculation Order
- Runtime Error 1004 - ODBC ERROR - BackgroundQuery
- Page Header: Loop based on values in a range
- Solved: Excel - Opening files in string or in cell
- Creating a "refresh data" macro
- Import Txt and Parse
- Sorting a Range with VBA
- Function returns empty array
- progress bar is frozen
- Solved: add data based upon created categories
- [SOLVED:] Application.match failing
- storing value, making registration tool
- vb and command button help
- Solved: Show current users on userform
- Writing Excel cells with VBA variables
- Solved: Generate numbers 1 - 90 for bingo
- Solved: userform and function call
- Solved: help optimizing case select
- Access Filter Criteria from Excel
- TextBox Help
- lookup and conditional formatting with VBA
- Using Formula To Find Last Used Column?
- Prevent 1004 Error For Select Method
- change part of a string
- Linked Picture to be centred on Screen
- question about forcemacros
- Solved: How to check the type of an array
- Solved: save and rename workbook everyday at a given time
- Using VBA for conditional Formatting
- Move over Picture
- Listbox Limit!!
- EXCEL USING IF THEN STATEMENT
- Ref Edit Control Missing
- Downloading many html web pages, converting to text, then parsing out
- Creating a User controlled pause in VBA
- Solved: modifying existing chart Sourch data
- Solved: Camera tool use with picture object
- looping code with if's
- Complie if error
- Solved: "Pick and choose" series to display on embedded chart
- Split Cells help
- saving a backup file
- arranging data redux
- Solved: Importing multiple space delimited text file
- Copy and paste withi selected range
- Excel in neverending loop
- combo box help
- Amend VBA Code
- Solved: Copy from one xls to other avoiding highlighted cells
- For Each.. loop decisions
- Manipulating Arrays Using VBA
- Seperating records with a blank line
- Solved: Help with Experimental Grade Sheet
- Quicker way to write a bunch of formulas??
- Which control does this?
- Difficult: Sum of days in consecutive months based on multiple criteria
- Function returning Arrays
- Solved: Formula help
- Solved: data going to wrong cell
- Solved: Spell Check Unlocked Cells on Protected Sheet
- Generate random numbers based on odds
- Solved: Populate list box from selection in another.
- Navigation menu to only show visible tabs
- Command button to Hide/Unhide tabs
- Solved: Re: Shared Workbooks
- Solved: How to re-apply named ranges
- Solved: Adding rows with preconditioned cells
- Solved: Changing TreeView Node Detail with Userform TextBox
- Form, listbox and multilines problem
- Solved: NETWORKDAYS formula amendment
- Solved: Find unique values
- Solved: Renaming folder files
- Extract data from columns [sum]
- Looping through Range Vs Ranges
- Tracking Changes / Sharing a workbook
- Solved: Userform Quick Q
- How to create a message box depending on values of the cell? Toughie =/
- Solved: Label blinking in the UserForm
- Solved: If value not found go to next cell
- Getting a range to work in my vba code
- Trim cells in variable range
- Copy, Find and add offset cell values
- Solved: Create New Sheet Based on Value In Column
- Userform will not Show after being Hidden
- Solved: Accounting format
- Solved: Automatically change font size
- Paste Copy special Value
- CSV Import Issues
- FileCopy to Network Drive
- [SOLVED:] Word bookmark Help
- Caopying and Pasting While Retaining the Original Cell Reference
- [SOLVED:] Quick question about loops
- [SOLVED:] Creating Pareto Chart
- Code using date not saving the result of output
- User Def Function to only act on active workbook
- Solved: problem with resize and autofill
- Solved: Opening unknown File names in known Folder
- Help with Macro code
- Solved: macro to list unique data in a column
- Conditional formatting in vba (more than three) select values from a worksheet
- Code Wants help
- Horrible Listview problem...
- How to draw a vertical and horizontal line on a line-plot
- Solved: Delete Row but store a value first!!
- Solved: CountIF to find Average using VBA
- Solved: Moving from 2003 to 2007
- Solved: Ideas to make this code faster
- Solved: Select All Pictures, And Move And Size with cells
- Send cell contents in email message body
- Macro to open workbook from another workbook
- Solved: Help on changing the year
- Help with code for data entry
- Solved: Multiline Textbox to Populate Multiple Cells
- Solved: Set variable to a cell address
- Excel - 2003 VBA Code Error - Run time error '380':Invalid Property
- Solved: Select range by used rows and named range
- add function on print
- Creating Add-ins
- Optimizing loop for find&delete shift column
- Solved: Macro:To Many End With's
- what does ^ mean in the formula
- Solved: Copy information to an Activecell that Moves
- Solved: Find and select a cell based on user input
- Call Excel Solver from VBA
- Passing listbox values to cells
- Solved: macro to hide/unhide select cells
- VBA Page Breaks in Excel
- Solved: create chart in seperated worksheet
- Image rendering in forms
- Match 2 columns
- adding code in runtime
- [SOLVED:] Creating Folders or Directories
- Solved: Headers & Footers - Multiple Sheets
- Function does not output on Cells
- Help Needed with Page Breaks
- Disable macros on opening via Hyperlink
- flips left-to-right sequence of selected columns
- Random Combination
- Copy multiple individual cells
- Solved: Conditional Formatting for Numbers Only
- getting string to resolve to variable
- adding access levels
- Solved: Print sheet in a loop procedure
- ActiveCell.Text
- Solved: Regex Query
- Fill data validation cell
- Getting a line in a graph to change colors
- Solved: Automatically Add Zeros in a cell
- Search, copy, and paste
- Javascript:_doPostback
- Solved: Merge cells into one if value is smaller than...
- Solved: [RESOLVED] Import a text file and keep the spaces
- Macro that automatically imports excel data into access database?
- Solved: Function in add-in - How to reference workbook?
- Problem with Range and Worksheets
- [SOLVED:] Split listbox text
- Solved: Excel macro to loop through rows, while looping format rows if meet criteria
- Solved: Numeric calculus for Matrices
- converting .ps to .pdf
- chart base on category
- Copying from cells on same row selected by user
- Solved: beginning with userforms
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.