View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
[
47]
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Excel 2007 for next loop bug
- What is the quickest way in Excel 2007 to export all modules?
- Limitation to Number Format in VLOOKUP?
- linking problem
- help for applying formula
- Reading a Range from a VB6 DLL
- Reference dynamic filename
- Reading a file
- Speed of fixed array versus dynamic array
- Convert to Number Issue
- How to create a To-do list in Excel20003
- forgot the password
- VBA look and Replace
- Backup routines
- How much slower is Excel VBA compared to Visual Basic .net?
- How to do it on excel?
- Printing contents of an array into a message box
- Text to Column with fixed width in VBA
- User Defined Types and Overloaded Operators
- Excel 2000 issue with ComboBox list entries disappearing
- On excel, can customer ID generate name address field?
- How to detect locked linked xls file ?
- what happens when this code is run?
- Update when worksheet close/delete
- Changing AutoSave location programmatically
- range not carrying over
- How to prevent vba code from running?
- Need Help - Small Macro
- "Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows.
- command button caption
- Searching external file for values
- If Cell is Null Enter Value of Cell Above
- Select range on a worksheet
- User Form List box, unique records listing
- Code to run Value of cell rather than the Formula
- using selected data from a pivot table to populate new list
- using selected data within a dropdown list to populate new list
- Button Problem
- Pivot Table help.
- VBA statement "scroll active cell to center"???
- Toolbar already exists, but where?
- Wrap not working
- Please help with my code
- Mandatory Cell
- disable a shape
- Error handling issue
- Modifying code to save data
- Error Handling Issues - Pls Help
- Initiate Macro via change in drop Down List
- Export from Access
- Search within a ComboBox list
- Declare Function for global use then call on change event
- Reusing Form Code
- Looping through
- Err 13 Cant find problem
- compare 2 x files with same colum labels but different aranged da
- Count Red Cells on a worksheet
- SourceData of a chart
- Numbering cells in a range
- How to get of all number rows in the autofilter range
- Accessing Excel worksheet names via ASP.Net 2.0
- Addin interference
- german text in english xls
- Loop and simple calculation
- time
- Problems with application.worksheetfunction.correl
- Error 13
- Calling Fourier plug-in from VBA
- User Defined Functions - Input prompts
- PivotTable VBA help needed
- check if values is already in listbox
- sending message
- Spreadsheet does not recognize my VBA function
- Merging data between worksheets using reference index?
- My Type Library is not complete
- Password Protection
- Sorting macro
- Remove VBE Component failed
- File Properties Location retrieve to refresh background query?
- Late Binding access reference in Excel Module
- Table ranges do not work in multilingual configurations
- Declaring a collection as a particular type of object or a particular class
- Data not recognized as a number
- clear contiguous fields with one keystroke
- Do Until Loop
- Find text then cut and paste it
- AutoRun
- Delete in different worksheets and workbooks
- VBA codes to get dates of files in a folder
- Deleteing columns starting at a certain row.
- Pictures on worksheet flickering as they are repainted
- Hide Code
- Rename Parent worksheet.name?
- How to move to next cell automatically no keystrokes?
- How to limit scrollable area
- Macro to Conditional Format if cell contains a word
- Userform Question
- Get data from Access tables in an Excel pivot table
- List box style
- String Compare... Tough one?
- Printing multiple embedded Word Documents
- Re: Insert Existing Data
- Macro type
- Change width of 51 Columns
- Hiding / unhiding rows based on change of a cell
- Please help with my code
- VBA can't remove drop shadows on bubble charts in Excel 2004 for Mac
- Textbox.Value as a new text file
- Using an Excel Spreadsheet as A Data source for Miscrosoft Query
- automatically sorting
- lock cells based on formula
- VBA Code Colors
- Linking Problem
- Excel 2003 DataForm
- How to activate a text box
- 91 object variable or with block variable not set
- On Change Search for Value
- Generate a combination list of values
- Identifying whether an excel file exists
- Data Selection for graph plotting
- Hiding Named ranges
- Email file properties via command button
- no calculation during readin large cols (Speed)
- Find last used row in a column (not in the whole worksheet)
- Re If statement....HELP!!!!
- Close workboook if it is open
- Create Summary then export
- Extracting data into a CSV file
- Using cell color in conditional format makes Excel unstable
- Formatted word file from an excel file???
- RTD Wrapper called for every cell in an array formula
- atm project
- textbox backgroundcolor
- Application.Enableevents = False doesn't stop all events?
- Refer to workbook
- [Automation] Why do my cells with formula appear as text?
- Long Code
- Calculation Project Date skip Sun and Sat
- Evaluate Formula with Named Ranges does not work if Workbook isalready open
- Evaluate Formula with Named Ranges does not work if Workbook isalready open
- Evaluate Formula with Named Ranges does not work if Workbook isalready open
- RE: Insert Existing Data
- Return Largest Value in an Array
- Cut & Paste Excel Format & Values to New Folder in PdF
- Button Won't Work
- VBS Script and ClearContents -- Code Throws An Error
- Error 461-Method or data member not found
- Transfering spreadsheet data to a master spredsheet.
- Error testing combobox to variable
- store default printer, change printer and then restore default printer?
- Stubborn Excel Options
- VBA Automation advice
- Edit Query Window
- Change Font Properties causes Excel failure on Save
- Do Loop Goal Seek won't End Sub
- Copy userform
- Entering text in a Form
- wrap text with quotes ("")
- vlookup query - 2 parameter check....
- Best way to send disparate cells to database
- Protecting XLA
- Change workbook path in formula
- Apply footer code to all new workbooks
- Need to find and collect all cells with a certain word onto a shee
- ListView control in Excel 2007 jumps!
- Pulling Data from one sheet based on value of column
- chart and automation error
- SaveAs in xlNormal Format
- cell address of hyperlink
- PasteSpecial failure
- Enum Members Declaration
- How to update data in a Control ?
- How do I STOP excel from making a Backup"filename".XLK file
- Changing From: emailing with Excel...
- delete element is collection
- Conditional Data Validation
- Remove and Add Text to Numbers
- Worksheet saved out as new workbook
- Code to filter a database displays no rows at all
- How do I show a "list" in an "if" statement?
- key assignments
- custom menu disappears when I File, Exit, Cancel
- RE: custom menu disappears when I File, Exit, Cancel
- Copying and Renaming New Sheet
- Find a cell based on current month
- Page print margin
- ThisWorkbook Problem
- Select method of range class failed
- Disable Worksheet_SelectionChange macros
- Data search and extraction from multiple text files query
- Copy after autofilter if range is not empty
- Can I get Excel to import XML like Access?
- Prevent the user from Edition / Erase / Format
- WorkbookBeforClose -> Cancel = True still closes excel
- Moving rows with grey background color to bottom (2003)
- Error with currunc
- Create DLL
- Filter a protected shared worksheet
- changing tabs from a cell from a difference sheet
- Limits of Excel
- Accessing another instance of Excel in vba.
- Not a 2nd print from the preview
- Sorting triplets...
- Re: select specific sheet and cell
- Re: select specific sheet and cell
- 1004 error when saving as CSV
- Is there any efficent method for searching in a large excel sheet
- update all hyperlinks to another drive
- Format Text & Numbers
- Iteration funtion
- Deleting rows that meet criteria
- If and vlookup in macro
- Write to Webpage
- No Prompt for Read Only
- reading range of data from excel sheet in C or C++
- Set Cell.Value = text & dynamic value
- Creating an Array from A Sql Statement
- Trouble with arrays (transferring values between two arrays)
- Code that sort of works
- DataForm Fields
- Copy non-contiguous cells from all workbooks in folder
- Constants Tied to Arguments in Methods
- Saving worksheet as CSV with correct usedrange...
- Excel 2007 User defined fucntion, cannot paste in mutiple cells
- Delete sheet on a condition: debug error
- Cell Format
- Exit from Excel edit mode using IDispatch
- Scaling problem with userform labels
- How to reset Used Range property of worksheet
- Excel Developer Version Solutions - are there any?
- Shell Problem
- Open MS Project From Excel & read Task Properties List
- selecting worksheet by its index.
- Controls Array
- If then else
- "Sort" macro in late bound code
- Please, help!!! How to keep userform from being moved?
- Save data entered into UserForm to be Edited later
- Error Adding to Spreadsheet Please help!!! Complex ?
- Pivot table refresh automatically when data changes
- Pivot table refresh automatically when data changes
- Converting Excel files to MS Project
- Stop Multiple Macros
- Run Macro When Specific Sheet Selected
- Caling fortran from excel
- copying worksheet to another workbook with a macro more than once
- Bordering Groups of Data
- Comparing 2 cells using vlookup
- Persistent classes
- How to select a range and save it as a picture (.gif, jpg, bmp, ..
- Searching for first 3 characters
- Multiple Printing
- Run time Error '1004'
- Copy from one box to another on a user form
- run stored proc from excel with a parameter
- Button Question
- copy and paste
- Page setup VBA help please
- Re: Vlookup Using VBA (without using VLOOKUP function)
- FilterMode does not work? Excel 2003/XML
- Conditional Locked Cells
- How do I create a string from a range (Excel VBA)?
- choosing from drop down list
- Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order)
- In relation to coding
- best lotro gold ,wow,mmo,how can i buy the cheapest gold
- best lotro gold ,wow,mmo,how can i buy the cheapest gold
- word processing within Excel
- Seperate massive data within 1 cell into individual columns
- Find range differens between two ranges/areas?
- WinDBPro. Ver 2.0
- How to create a setup of excel application with macros in it
- how to select a single column when this column cross a merged cell
- Reference different versions of Access
- Deleting a macro using a macro
- Formula for S-Curves?
- add new chart in 2007
- sql issue
- performance question
- WairForInputIdle
- Cell Value to String?
- Custom Menus With Excel 2007
- how do I combine multiple excel files into one?
- Is this even possible with VBA?
- Filling an array with ranges
- copy and paste
- Inserting chr(10) from script
- Statistical function problems
- Excel application level control for Excel 2003
- macro to change tab name to file name
- Accessing data-subtotal via VB
- hyperlink address
- HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1) >
- get values and colors back in a cell
- How to know which pivotFields was changed through Private Sub Worksheet_PivotTableUpdate
- Is there anyway to retrieve Registry Values from VBA???
- Need macro to go to next blank row, copy formulas into next row
- Object Module Constants Scope
- Formating
- Sum based on ranges pivot table?
- Auto Close Yes no button
- Inserting 2 rows above a certain cell
- Naming a cell according to its contents
- Query SQL Data in Excel with a function?
- TextBox Accessing Contents
- 2007 UK Excel Conference - Nov 29 - Dec 1, Cambridge, England
- Application.Match on an range defined to a variant array
- Can this Code be Condensed
- Graph on a form
- finding values and put them in a listbox on visual basic form
- validation
- Help - Create a range that will update automatically to be used in formula
- mail merge
- Overwriting existing files
- Keep Change History For
- can someone please tell me what i did wrong with this if statement?
- Conditional Formating
- Pause a macro for user input
- Add value if date is in an interval... tricky?!
- Booking sheet
- lookup formula or a macro?
- Problems with a Combo Box
- visual basic - select/activate but don't show sheets
- Programmatically setting Conditional Formatting to a range of cells
- How manipulate a picture with recording macros?
- solver problems
- Initial position of floating toolbar
- Macro Recording Excel 2007
- Clear check box problem
- validation if a string is a proper function's name
- Call back a Dim variable
- Office xp
- Add leading zeros fill space
- Using Worksheet_Change(ByVal Target As Range)
- How to copy and paste row as a text within workbook including numbers
- KeyPress: how to delete last character
- run macro whenever any cell is changed
- Breaking a row into multiple rows
- RE: !!! SOFTWARE 4 SALE !!!Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â *Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*
- Using SumProduct in Code
- Excel - Passwords
- Calculate the number of days between two dates
- Text formatting
- number formatting
- Create Outlook Contact Error 13
- Problems evaluating defined names in VBA
- multiple sheets
- Re: compile error, need to simplify/shorten
- list worksheets in a workbook.
- copy previous row down 5 rows
- End sub routine, move to next
- Change Cell focus base on value in first Cell
- Average data and delete a row-need help
- Making 5 Minute Wind Averages
- Code to change code in a sheet and workbook module
- CommandBarComboBox : AddItem - procedure to attach routine.
- Store strings in a Define Name
- Find a picture on a worksheet
- SUM function Help Please
- Using VBA to print a range
- Scattered Cell entries into one Column
- Re: Please help me simplify the given code
- From Column A get Text from Colum B
- Can Excel 2003 VBA module be renamed
- Re: Pass named range to user defined function returns #value!
- Help wanted
- Re: Pass named range to user defined function returns #value!
- Re: 2 Lists but different time frames.
- RE: Dynamic formula creation and p;acement
- Variable in Message Box Q
- Need help with Visual Script Code
- RE: Copy formula to cells on the basis of value in row 1
- Re: Code Execution Has Been Interupted
- Digitally signing VBA Project
- RE: Spreadsheet to access
- RE: Vlookup Using VBA (without using VLOOKUP function)
- Re: Pass named range to user defined function returns #value!
- Subscript out of Range Error if Null
- Is there a way of finding if the user is a system administrator?
- Range Next
- Seelcting specific sheet and cell on startup
- Delete rows
- Wild Card in button caption
- Recording a Macro
- How to offset a row
- vaRecipient = multiple names
- Benchmarking Range to Variant times
- Error 1004 Display Alerts
- Coring on calling VBA6 dll
- Rename Modules
- New to Excel programming
- Run loop until
- remove "+" from =+ABCD.
- Capture Forms button caption
- dsum evaluating only the beginning of a string?
- how to separate sets of text and numbers in a line with a macro co
- Workbook.Open() Fails in Vista
- Macro to Add Comments to Cells
- Closing file with Macro
- Excel 2002 has encountered a problem and needs to close /Code Clea
- Cant Digitally Sign Excel VBA Project
- roto13
- CONDITIONAL SUM WIZARD.
- wild card *
- Calling Functions
- How Can I Loop through all the range names in a workbook in VBA?
- PrintOut problem
- Open excel file and reffer to specific worksheet
- Using Mappath
- Excel wants to save an open file to another filename in VBA script
- cannot autofill 2 cells info at the same time
- Object instead of passing arguments
- Digital certificates
- recursive or loopless combinations
- Aplication.Worksheetfunction.MAX() Stopped Working
- command button
- find cell address of last active cell in range
- Sumif - Non Contiguous Columns - Syntax please
- How to change textbox caption in Active sheet from UserForm
- Setting Range Name using R1C1
- Apparently not possible?
- Command Bars
- Validation List
- Removing an addin from the available addins list
- Is there a way to change columns index with Excel 2007,or is it a
- Group and ungroup
- Splitting strings, error subscript out of range
- Possible bug with clipboard data? - Need Advice
- Drop Down Box - Deleting Items but it repeats what is left
- limiting rows
- Find Certain Cell Value and Print that Page Number
- Writing a Macro to Find & Delete Target Rows in a Range
- Make file drop dead on close
- Manipulating Arrays
- Textbox control
- No need to register assembly of DLL written in C#
- AUTO/MANUAL Calculate in Excel when opening *.slk files
- Pivot Table - I can't delete unused values in selection drop-downs
- Pasting info from another sheet
- Loading an Excel User Form
- Messed up references when copying sheets from one workbook to anot
- Copy Sheet
- Macro to remove word from text in a cell
- Printing move my camera picture
- Using a named range as a source for a combobox on a userform
- passing a parameter to an excel macro from a form control
- If Folder Does Exit Create
- Clearing the Contents of a range of cells
- Printing macro code
- Copy row to next empty line
- Excel charting options using VBScript
- Calling a function
- Copy and Paste
- Error Message Box
- RTD cannot return an empty value
- If Null Set Value to Zero
- evaluate a year expression
- Response to Userform Problems?
- Trouble reading to object
- Select Multiple Ranges with Certain Data to Print
- Userform problem?
- Establishing a default on dependent data validation lists
- Control names on userform
- Search cell for string
- Excel 2007 AND Retrieving Data from Stored Procedure on SQL Exp 20
- Open another program (VNC Viewer) and insert an address
- Simple Macro... i guess
- Open excel workbook within macro
- Solver programming in VBA
- What Name for GetIDsOfName() ?
- HELP!!!!!!!!
- Userform with Unicode strings
- Query - Formula (Test for string)
- If X = Array?
- imput box
- do we have constants for maxRow (65536 in excel 2003) and maxColum
- sending active sheet by mail without macro (from Ron's page)
- Move cursor out of sight
- excel file properties question
- Combo Box_Change
- Nesting Collections
- How to make Class Module universal
- Work book event code help (re Bob Phillips)
- UserForm Window size setting
- Delete a Pivot Table
- Convert string to date problem
- System Errors Occurs Enable Macros
- vlook up formula help
- Export 1-dimensional array values to a two-dimensional table?
- How to save OLEObject to hard drive?
- "Or" statement not working
- Macro
- open outlook and add email address
- Circular Reference Notice
- Excluding one page in a macro
- Multiple printing of cell data onto new worksheet
- help Compare string to Combo box!!!
- Relative reference to current cell?
- Old question new twist?
- How do I macro sort with a varaible range (differing last cell)?
- convert a range of text into numbers
- Advanced Filter Advice
- Help with programmingBorders
- error when opening a workbook
- Run-time error '-2147418113 (8000ffff)':
- Camera Tool
- Disable Security Warnings Screen
- Cells not calculated
- Not getting the values
- Summarsing Variable Pivot Table Data
- Dynamic Conditional formatting
- Consolidation
- Automatically Execute Excel Macro at 6:00 am
- Auto Filter-VB
- same than end(xldown) but stops on hidden cells if not empty
- Selection.Copy on Temporarily unhidden excel sheet - possible bug?
- Fill Down to Stop at Last Row
- UDF Prompts in XL2003
- Linest in VBA problem
- Copy values in a range to memory
- Set Range of Visible Cells
- Can I learn VBA quickly and how?
- How to do the filter when applying formula to a pivot table
- getting file path
- send o outlook graph in html format
- ArrayFunctions: How do I... ?
- import data from excel under Mac OS
- Need help with Excel Macro for searching
- for each in range gives variant array
- range or string or long type
- How to use Decimal data type?
- convert text to number
- Data inside Cell Seperated by comma
- Upper case in textbox
- Copy Excel Ranges to PP in Office 2007
- Replacing information
- Sort by more than 3 criteria
- Remove non-printing characters
- Do Until Inputbox = loop count
- Help with Date Format
- u mann whitney
- xls to csv conversion
- help - how to list all excel files in a folder
- Export from Access damages my Excel-Workbook
- Passing a value to another macro
- Compile error in Userform macro
- Can I create custom symbols library?
- Can I create a custom symbols library?
- Excel Open error
- How to check date format in display cell value
- Access vba to Excel
- do not increment variables in excel
- Creating a Copy/Paste Loop
- export excel entries into a calender format such as Outlook
- Opening and processing all files in a folder
- Copy ranges into email - HTLM and Text format
- Button with hyperlink and asigne macro
- Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
- formula not working
- Conditional Formatting - Range
- Counting macro
- Macro misteriously crashes Excel 2007 - but not 2003
- Validation code not working with pasted data
- Formatting and Ignore error
- change column fill color
- Data Selection and Averaging
- If a cell equals then macro
- Excel AddNew QueryTable '1004' problem
- What does the compile debug option do?
- Problems seraching newsgroups with Google groups..
- Excel Automation
- How to paste data into sheet?
- How to paste data in new sheet?
- Trim the entire range
- Nested IF's
- Conditional Formatting - Color row based on one cell value
- Disable inserting or deleting row in selection of rows
- Excel 2003 VBScript
- Hide Headings / Group
- Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?
- PasteSpecial Excel Chart in Powerpoint
- Disable Dropdownlist (Combobox - "Form Control")
- Help with creating code??
- select multiple cells
- Use VBA macro to populate formula result in 'next blank cell'
- Loop through SpinButtons on a Worksheet
- Help to improve UDF please
- Search column
- difficulties using vba to save to the desktop
- Copy Data From Worksheet to Another Worksheet
- data validation defaults
- Events are not disabled
- VBA is Mangling a Query
- Defined Name Formula
- Can I Write A Macro That Will Execute Fomula In The First Empty Ce
- CommandBarButton with toggle property (up & down)
- Picture question
- Enter login details on a web page using macro
- Data mining
- Load TextBox With Search Result Cell From a PAge
- Loop through column(s) to check values, perform action based on check
- USERFORM X BUTTON
- Ditributing ComAddin's & ActiveX-dll's in Vista
- function with a range as a parameter
- Using FSO
- Copy row 21 from all sheets to a new sheet except " summary"
- How to manually regist the com add-in for excel2007
- mininum with referance
- Error loading type library/DLL for MSFlex Grid
- Progress box
- How do you do a file search in XL2007
- Full hyperlink issue, please help - end of my tether lol
- Macro to run an Existing Microsoft Access Macro
- Complex SUMIF
- separating data from imported txt file into cells
- Code is changing date format
- Re : Excel CheckBoxes to be activated by VBA
- No Out put from UDF
- Adevance filter using VBA not show the requested data
- How to return column number
- Character Month from Date Data type
- Custom help attached to CommandButton
- Game?
- Average the sum of numbers in a list or table
- Data Recovery
- VB code for Excel sheet
- Inserting Many Images
- Question on Web Query .iqy Control Variables
- Automation error?
- print multiple sheets with page 1 of 2 type
- Paste formula in a specified number of columns to the right
- Excel Conversion in Progress dialog
- Want to find/read excel files in SharePoint
- another autofilter question
- automating linking icons to different hyperlinks
- Excel automation: how to disconnect correctly?
- Join two tables
- Break Up A Spreadsheet
- Excel DocumentProperties
- Excel VBA - Max Function - Syntax Error
- VBA chart problem
- Excel date conversion in .NET
- update validation when change source
- Looking for VBA sub to Invert and Multiply matrices
- Automated .PivotItems boolean value
- PivotChart Formatting and screen updating
- event failing
- UDF to find end of range
- Calendar Control for Excel 2007
- Adding the values of a sorted column if some cells contain #N/A
- Print spreadsheet replacing recipient name
- Error 91 Object Variable not set
- Merge multiple worksheets into one worksheet.
- macro to compare data in column A of sheet 1 with data in column A of sheet 2
- Macro to add three seperate groups
- Vadlidation code not working
- Breakdown Excel 2007 worksheet to 65,000 worksheets for Excel 2003
- Run-time error 9 when trying to copy a worksheet
- Countdown Timer - not stopwatch
- Create rows from existing rows
- How to instantiate Excel 2003 when both 2003 and 2007 are installe
- downloading, opening and parsing a csv file
- FaceID for CSV-file (Icon)
- An easy question
- Office 2003 Buttons Invisable on a seperate computer
- Use Access VBA functions from Excel
- Change Negative Numbers to 0
- execute formula
- Find and Replace Dates in VBA
- Spilt data into two columns
- Workbook_SheetSelectionChange in an Addin
- Function Error, Returns 0
- Select limited character of a cell
- char to numeric value
- Com Addin Issue
- How to cancel midway?
- Year Date Format
- How to run VBA code at low priority?
- Year date format
- PrintTitle using macro
- Somekind of lookup?
- excel file size problems
- Dialog Box and mouse selection
- Name of SMTP server
- Using Now with microseconds Excel 2003
- range.comment.Text(...)
- Function prototypes in Excel VBA
- The excel calling msquery question throught DDE
- the excel calling msquery question throught DDE
- Autofilter on non-active sheet
- Checkbox from control toolbar macro
- VBA - identifying which worksheet is active
- VBA - identifying which worksheet is active
- Non-zero cells returning zero
- Print on worksheet
- Loop and variable type
- Sending e-mail with Excel
- best approach for overcoming Input box errors & code optimisation?
- Re : Excel VBA Array to be expressed as a variation of Partial Dimension
- Excel Automation
- Easy Loop question (with delete row)
- Can I create a macro to adjust the height of the cell according t.
- Pro Football formula automation
- Ribbon events???
- Using Autoshapes as macro buttons
- Help with applying code
- accessing data in backend workbook over vpn, is it possible?
- Macro to enter week day dates only
- Enable or Disable Forms Button on a worksheet from code
- Inserting Pictures Based On File name
- Why does ControlSource in Excel return a US-formatted date
- Problem with Excel 2000 automation
- Compare Sheet1 value to values in Sheet2 Column A
- Pictures not displaying
- RE: Help with code issues
- Having data source and query code issues....
- Repost: Update querytable connections and refresh data
- Comparing two columns in two different worksheet.
- Macro to enter week day dates only
- How to test Excel 2003 & 2007 macro security level
- Date format on opening a csv file in Excel 2007
- Help with code issues
- Unable to Read file
- Str function does not work
- Sheet change or sheet calculate?
- Question on VBA : how to detect "idle" condition
- Macro
- Number of Columns
- Increment Letter in a String
- combobox population question
- Charting from a different range location
- Can anyone recommend a good book on xls query and pivots
- Speed Up this Macro? Part 2
- How to use the name for an array by using a variable?
- Code to delete shapes each time a sheet is deactivated
- Event Macro - On Cell Activate - Change Cell Format
- Code stops after column "L"
- Avoid Scientific Notation
- Unable to read file
- change attach workbook code to worksheet
- Combobox questions
- Auto row insert
- compare contents between sheets and identify matching values
- Unable to read file
- Pls help me in finding duplicate entries in a column range
- need macro to save HTML pages as PDF docs
- Close Buttom
- VB CODE REQUIRED..........HELP PLEASE
- Aiuto programmino con array
- please help
- Changing a macro from a specific worksheet to any worksheet
- How can I refference then search text in a worksheet text box
- Named Ranges in Functions
- Starting a Macro where the cursor is
- type 13 error
- Excel 97 - Excel 2003 Macros
- Speed Up this macro?
- Move and size a object on the sheet
- Moved cell & Ref
- Use SUMPRODUCT and avoid rows with #REF!
- Using an Input Box To Define a Range
- filter duplicates
- Excel Formula or Macro
- ActiveChart.SeriesCollection(1).Points(3).Select ERROR
- Centralized event handler
- Data Validation based on first, second or third data validation li
- Limit the input in a cell to a single character
- Using ActiveSheet to Disable Multipage1
- Excel 10.0 Object Library ---> which Excel version is it?
- how to select cells from a non active worksheet
- Inserting rows
- Creating a Check Box that produce true or false statement
- If Font.ColorIndex = 3, Copy Entire Row and Paste to New Sheet
- Help with code repair
- Formula in a macro
- sub won't fill down via code
- Iteration
- Using "Like" to match strings
- ActiveWorkbook.SaveAs question(s)
- Open and Enable xla file from vba code?
- Update querytable connections and refresh data
- Wildcard in workbooks open code
- Calling a public Macro from a Private Macro
- type mismatch and/or obj req error from inputbox
- Filiter and Limit selection in Combo box / List Box in the UserFor
- Make Variable Range in VBA
- Excel PID process casting
- Run a Word Macro from Excel VBA
- Worksheet_Change Event
- convert workbook to html
- What is going on during a workbook opening?
- Copy Validation to next row
- Check Box Macro
- Listbox in excel data
- Problem with Pivot Table Fields In Field List Not in Source Data
- A problem worth gurus, I'd say ...
- Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6, OwnData 2.6, VantagePoint 7.0.11.2, other ...
- Lookup last value
- Make ArrayOne = ArrayTwo
- Programming Excel to send emails
- Problem with dBase
- Changing the ActiveSheet
- Using VBA to open Excel , Auto_Open Procedure not running
- Check Box macro
- Access to the value of a merged cell in a formula
- Formatting a Pivot Table
- Hi, I am Starter in Excel Programming
- Reference of Range in another file with VB
- Itreration
- Receive Error File Not Found
- Sort by unique values and sum
- packing slip
- protect workbook
- Database summary
- Tool Tips on a new
- On change event for specific cells
- prompt for parameter/criteria
- Database Functions
- Delete Rows that fit a certain criteria
- cant see the macro
- VBA finding language versions
- Type Mismatch error
- Re-setting Forms Spinners or Combo-Boxes
- How to declare the active worksheet?
- Do indiv. sheets (or cells) have "TextToColumns" properties?
- Excel sort formulas
- validate and offset
- formula refresh problem
- date range
- Relative Range Selection
- Edit Links
- Allowing user to locate and select a file and save results in stri
- Slow Code
- listbox selection to load to new form
- find names of routine in modules in many workbooks
- Save range to text file.
- Programally add a Macro to Multiple Sheets
- How do I display time in gmt when my system clock is set to local
- Macro to slightly modify the subroutine
- Why my workbook suddenly open slower than before?
- Exporting Excel to Word
- autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks?
- Get data from another worksheet in same workbook
- splitting cells programmatically
- Open a specific sheet with VBA
- Excel 2003 - Code to print and/or delete
- Controling Matlab from Excel
- How to make this work??
- How to get Excel results into Word
- Combobox and spinbutton causing object disconnected error
- Run an HTA as an embedded object in a sheet for help
- VLOOKUP with 2 criteria
- Copy non contigious data from another sheet that meet criteria
- Print Macro
- Chart Placement incorrect in macro due to differant screen resolutions
- Run Macro based on IF
- Resubmit of Macro needed to search 2 columns
- A negative to using Application.Onkey
- Getting own workbook
- Can't remove problem reference
- Import Access 2007 report to Excel
- Serious help
- input box - user selects range with mouse?
- Error running GetVersionExA
- Sorting cells in Shared Workbook...
- Choosing what information to filter from SQL in VBA
- filtering he data is not always correct
- Problems with long text
- Error LineStyle property of Border Class
- Insertting multiple rows
- insert images/pictures
- run macro on a CommandButton from another sheet
- sheet names displayed in first workbook sheet help
- Decimal Point Placement
- Hide WindowsMediaPlayer1 Media Control Bar?
- Graph series collection
- Enter in a workbook and copy to another automatically
- lookup from one document to another and paste in adjacent cell
- Create a Macro to Delete All Rows that meet a certain criteria
- Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column
- Getting excel process id
- Turning off/on protection in a macro
- Variables Name
- Trim content of a column
- Attaching a function
- removing leading and trailing spaces
- How do I create a picklist macro?
- Can I Delete A Module On Exit?
- Adding to A Collection
- Update two cells by changing another
- Change size of font if cell value is greater than 0
- Macro to check data from excel list against access query and return value back to excel
- ActiveSheet not in ActiveWorkbook?
- Picture pasting where it should but also in alot of cells it shouldn't
- Selecting rows and columns up to a certain point
- Workbook_Open event fails to fire
- Creating COM Objects or Add-Ins from VBA
- Opening a Shared File
- Update txtbox from combobox
- How to select program to open Hyperlink?
- Macro needed to search 2 columns
- Date Calculation - Continuation
- insert page break at each change in column B
- Code question
- Link spreadsheet control and Excel worksheet
- Find source WS from Chart
- subscript out of range (help)
- Create WB, create new Sht, paste data. (Macro not working)
- explanation
- Vba has errors on other computers but not mine
- delete rows if cell in row contains "a" or "o" or empty
- Help with code issues
- Print one-sided and override two-sided default
- Deleting columns/rows
- REFEDIT.DLL???
- help on sizing a check box created using the Forms toolbar
- finding the scale on a chart
- ctrl-p
- Inserting multiple rows...
- Macro imports data into cols A,B,C. Would like the data in D,E,F
- Help with compile error
- Condition Formatting Code for text in cells
- Print an Embedded Word Doc
- How do I get a list from an excel sheet into a userform/listbox?
- Explanation please
- Custom filter setting
- Object LIbrary Versions 11.0 - 10.0
- SYLK files Excel Picture format
- Some wierd and wonderful macro required
- Sumif SumProduct Several Criteria
- keypress interception
- Determine data type in a string
- Error on all My Excel books
- Test for Values Q
- Close worksheet, dont save
- Error Loading UserForm
- Macro to add word to existing text in different worksbooks
- What is the maximum number of unique strings in Excel 2003
- Message box and loop
- Count Specific Total Numbers from a Set
- McAfee problem
- User forms
- WindowsMediaPlayer1 Mute Sound?
- macro to filter rows containing user defined data
- SUM Macro
- Manipulating arrays
- How can I reuse function for a userform button
- My code works in command button but not in public sub
- Correct approach for clearing memory with repeated Database queries
- setup project for Excel addin, won't register addin
- combining different size tables
- Newbie : question on VBA and checkboxes
- how to bring a value from access into excel based on criteria
- Macro to Paste Data in Non-Office Program
- Set Row as Variable...
- Check Cell Content before continuing...
- Change code to popualte into cols D,E, & F instead of A,B, & C
- Moving columns about
- Txt file properties
- Copy data from Workbook Alpha & reorganize it in Workbook Bravo
- Consolidate a worksheet from different workbook into one master
- Named range prob using VB to move wksheet to an existing wkbook
- Search Multiple Sheets Then Add Txt1.Txt to Cell
- VBA Imaginary Breakpoints Error
- Compile error - Can't find project library ????
- Compile error - Can't find project library ????
- Need Help Expanding Macro
- Counting Occurences According to Time
- Macro name issue
- Excel Equivalent of Access OptionBox
- Error: Block If without End If
- Macro to change the column references automatically
- Macro copied from ng returns a #VALUE!
- Line break in cell
- Borders on Fixed # of Columns, Variable # of Rows
- Borders on Fixed # of columns, Variable # of Rows
- Menu Vanishes on Opening a Worksheet
- averages with formulas
- Selecting which macro to run based on a user entry
- BeforeSave event
- Updating Custom Menu Code References when New Workbook is saved
- Change Default Printer Causes Abort
- Query Close code question??
- Pivot cache when pivot table copied
- Alternative VBA to copy a worksheet
- Toggle buttons, Check boxes
- Select Entire Row if Text is Red
- simple edit
- clearing memory using VBA
- Insert Row Specified Sheet
- Run-Time Error and UserForms
- Sum macro for a variable "i" in a loop
- Sum Left Formula, Excel 2000 & 2003
- Sum that ignores text
- how do i link a picture to a vlookup result?
- Text box value lost
- Move Worksheet from one Workbool to another - fails on Excel 2007
- API Class Question
- Exporting / or copy to Excel
- VBA Code : Example 9-1 David Bourg's Book
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.