View Full Version : Excel Help
- Solved: Dynamic Conditional Formatting
- 'For' loop
- Solved: Count number of cells and export to Word
- Solved: Validate Input Data in Userform
- Solved: Save current workbook to filename in format dd.mm.yy+string variable
- Loop through listView & update checkbox
- Opening A Sheet From A Combobox
- UDF to calculate moving average
- Sleeper: Can't shut down excel.exe process
- Convert sql to vba code
- Solved: Several issues with my code
- [SOLVED:] VBA Email - Reply to Address
- Advance Filter
- Solved: Dynamic List of Worksheet Names based on criteria
- Solved: Copy & Paste and Adjust Data
- Copy & Paste data from column I
- Want to convert a Date
- Switch to an Active web browser windows with specific title
- Categorize Deadlines Based On Past Due/Period Remaining
- Comparing lists in columns?
- Solved: Userform query
- Solved: Colour entire row
- Solved: Timing my macro
- EXCEL CHARTS
- Solved: subtract date/time formatted fields
- Accessing Addin functions with VBA
- Calculating installments left
- Can't get PasteSpecial to work
- Solved: fill blank/black cells with 0
- Solved: Copy more than one sheet to new workbook
- Calculating project time
- Run Command When Push Print Button?
- Solved: Getting Rid of an Annoying Feature in Excel
- Getting date format in comboboxes?
- Solved: VLOOKUP Help
- Time and column spacing
- [SOLVED:] Want to halp USEFORM
- How to change mixed case names to proper case?
- Solved: Force Hide Formula Bar
- Validating values of a column in a file from another file
- Solved: Script out of Range on Variant Array
- Solved: Problem when trying to use close method of workbook object
- Sum not correct
- Modify a macro
- Solved: Dynamical generate name ranges
- Find and replace (Excel&Word)
- Logging into website
- Solved: Amend Macro in worksheet Cashflow Yearly
- Solved: SearchWord Help
- Solved: VLOOKUP AND COLUMN FUNCTION
- Solved: Alternative to "vlookup" function
- Solved: Tricky copy and paste macro
- Solved: Automatically Update graph
- ploting the graph according to the sheet selected
- ploting the graph according to the sheet selected
- Rowheight plus a little bit more
- [SOLVED:] Delete Rows that contain X in column Y?
- Modifying the existing graph
- [SOLVED:] Beep in Excel
- How to select changing cells within a column
- [SOLVED:] How to paste X in column A according to the length of column B
- Amend Forumla
- [SOLVED:] Return a Range in a function
- Debug Help with a Delete button
- Viewing records in workbook\worksheet form
- Email/Excel/based on a condition
- [SOLVED:] Ranges as arguments in a VBA function called from the formula bar
- [SOLVED:] Between dates in vba
- [SOLVED:] Dcount Last Character In Column
- Solved: List all files in folders
- [SOLVED:] Summing Macro
- Solved: Add To Code
- Solved: ListView control with images
- Data shifts on adding new customers
- FONT COLOUR DROP DOWN ON CELL
- A program to delete certain cells
- Solved: IF THEN COMMANDS??
- Solved: Vb New Line
- Chnage formula to ONLY allow column D and K
- Email Run-time error predicament
- Problems with Saving permissions
- Networkdays Formula
- Solved: Find cell and return value as string
- VBA Cell value mutiplication
- Solved: Need help with Loop routine to enable 20+ checkboxes
- Solved: excel2000 question
- Solved: Save As an Excel using VB
- Count non-hidden cells in a pivot table
- setting a workbook as a constant
- Hide value in Listbox if 2nd Column = 0
- Solved: 2 dimensional dictionary object
- excel spreadsheet to .EXE
- Solved: sum values based upon 2 conditions
- SUM/COUNT CELLS BY FILL COLOUR
- Solved: Very Custom Program
- Processing XSD schemas using VBA
- Double Entries
- Solved: Populate Listbox with Mulitple Columns
- Copy data from web
- Solved: Leave TextBoxes Blank
- Solved: Hide Row Based On First Few Letters
- Solved: Change PivotTable Data Field in VBA
- Solved: It's late, please help simplify this formula
- Error's want to help
- Copy variable range and copy to another sheet
- Solved: Save as Filename with a variable text
- Set SummaryRow format
- Combine2 Name Colums to Create emails
- Help with Replace Function
- Edit a cell depending on previous choice.
- Solved: Available Resources issue
- Solved: Vlookup from data in unopened file?
- Solved: variable not defined in
- How to enter date into pop up, which enters into spreadsheet
- How to compare the difference between 2 excel files
- Create request
- Last Duplicate Value in Column
- VB code
- Solved: Followhyperlink code
- Solved: Custom Formats
- Copy data from Multiple to SINGLE worksheet.
- Pivot Page fields to new sheets
- greatest date and time
- Solved: adding locked cells via macro
- Solved: Copy range from one sheet to another
- Solved: Copy row of sheet2 (if data does not match sheet1).
- Advancedfilter Delete Row(s)
- IF STATEMENT TO extract result
- Solved: Alter Code To Allow Spread Sheet To Close
- Insert today's date, save file and close
- Excel Signing Invalid because of XLA location change
- Insert column
- How to delete all rows that don't have a specific name - e.g. "XYZ"
- Number format Question?
- Run macro automatically when a cell value changes
- Select check box on web page
- highlight cells between two dates in cluding the cells with the dates
- Font color
- Help using Excel as a database
- How to give a dataset corresponding ranges?
- Print when Command button is pushed
- [SOLVED:] Message Box Input calls Tab Name
- [SOLVED:] Loop for Value True/ Copy 4 cells to other sheet
- VBA Question - How to find the contents of one cell in another worksheet?
- Solved: Macro Problem - Hanging
- Solved: copy sheet and change formula reference
- Solved: Removing numbers from a text block
- Sleeper: Linking worksheet together
- Formula Error
- Code to allow A Customers ID to only go in a spread up to 3 times?
- Place in first empty textbox?????????
- Placing in the same row as a spefic customer
- UDT Question
- Solved: Save button
- Solved: How can i?? Press a button and it will make a calculation of +30days!
- Solved: What can i do when it says not a legal object name.. and then wont let me do anythin?
- Solved: Save button
- When using a combo bow to select a row
- Solved: find duplicate entries in colunms
- Solved: Edit code to change cell value
- Solved: Loop through sheets
- Solved: Restrict Menus & Right Click Menus & short keys
- Solved: How can I create linked Vlookup data from multiple closed workbooks
- Find and Replace Page Down in excel
- Multiple Charts To Multiple Slides
- conditional adding through sheets in a loop. Novice.
- Solved: Jump to last worksheet
- Runtime error in macro
- Solved: Save in both Excel 2003 and 2007
- Solved: Remove ' from text
- Simplify Code
- Duplicate Master freeware utility?
- Custom Sort
- Sort, Page Break and Page Header according to cell values in different worksheet
- Solved: Passing variables through properties
- Sub or Function for IF ...
- Split text between cells Help Needed
- collection issue with custom type variable
- Solved: move sheets to new book (array)
- Copy and paste data after printing
- Solved: Partial String ListBox search to populate another ListBox
- New Excel Application
- Solved: Green if zero, Red if not
- Subtotals using Macro ...
- Notification when macro is executed
- Solved: Notification when macro is executed
- Solved: How do you return / pass values?
- When looping through sheets remove subtotals only works on first
- Solved: Combining macros
- Using a combo box to select a named worksheet
- Command Button to save, print and clear
- How to delete a row if it contains a word?
- Solved: Code change to allow for Data table changes
- Solved: Loop through one column on any sheet in workbook....
- CommendBox
- Solved: Feeling dumb today!!!
- Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet
- Solved: Add Border if Statement
- Count coloured cells and display result in table.
- Group 2 cells like in a userform.
- Excel Right Click Menu Always Up
- rectangle question
- Solved: Saving As Text adds double quotes to some lines!
- VBA for time display
- Check if a file on the web exists
- Controlling Internet Explorer's "Print pop-up"
- Clipboard is full
- Solved: move up
- Random number generation
- Summing a column based on two criteria in other columns
- Listview help
- Pass a named range into function issue
- How to find the last duplicate value
- Solved: Problem auto-installing VBA add-in
- Formatting entire row based on text in first column
- Combobox Visibility After Drop List Selection
- Help! I'm working with two spread sheets
- [Help Please]Parsing parameters to event
- If no dependents msgbox and resume loop
- C&P all data of all the sheets/workbooks in a folder.
- Execel, OLEObjects (buttons) sometimes not firing, triggering
- Excel Macro Help Please
- problem using a function from an external library in vba
- [SOLVED:] Variable Columns Lengths
- Solved: Create a worksheet for each value in Column A
- Split string into multiple parts no bigger than 240 chars?
- Solved: alpha-numeric 2
- Solved: case yes-no, can the code be smaler?
- Easy! How to make a button that generates a random number?
- Solved: using a worksheet function in vba
- Solved: Sum and compile list of entries
- Solved: any value in a range = 0 then return 0 ?
- Solved: From one array to another
- Solved: problems saveing two copies.
- Solved: Userform buttons to enter numbers into textbox
- Solved: problem of structure
- copy range, skip empty cells
- Solved: Fast Compare using Filter
- Alternative to Eomonth formulae question
- Solved: make a dynamic if statment?
- Solved: Special Transpose
- From one sheet to another...
- loop + offset/resize problem
- Extracting certain data to another sheet
- Macro Security
- worksheet is not picked up in Vba
- Solved: Stop Them Deleting Rows
- Solved: Hours to be worked by Month
- Date Format
- MACRO/VBA help!!! :S new line... etc
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.