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 |
- Using VBA to track workbook changes
- List all the named ranges & the cells they refer to on a blank she
- Problems with saving WorkSheets that have External Links
- replace VBA run-time error message with custom message
- Excel Macro
- need to make code more efficient (if possible)
- Excel import
- Macro using Save As Problem
- How do I get dates automaticaly inserted when editing excell
- Can't get past Line 3 of code
- VBA & User Form modules vanish
- Select columns when drilling into a Pivot Table
- Loop for copying data, then pasting in a continuous row
- macro to print a sheet if a cell is a certain value
- Keep calculation time down in large Workbooks
- End if with block if - Pivot Table Problem
- Loop and name
- Configuring Excel 2003 to control access to Trusted Publishers
- Export from excel into an invoice template
- Event when selecting an item in a combobox?
- Got the Copy/Cut Code But what is the Paste Code
- Runtime Error -2147417848 (80010108)
- better way
- Return reference from object function
- Global Variables
- Search and open feature
- Insert VBA code user a macro
- Return Array Dimenions
- Closing Excel Program correctly?
- Chart making
- addressing type in FormulaR1C1
- Hide columns in macro while protected
- Error loop through #N/A values
- Quiting Excel program?
- Changing the row and column in R1C1 formulae
- call macro X by cell value
- Macro to extract the data in a certain cell
- Can one close Excel progarm with a macro
- load event when specific workbook is opened
- Legend moves across chart
- Function returning null value instead of string value
- Help with MAX code
- positioning charts
- Put worksheet names into worksheet Excel 2000?
- TextBox question
- How to format cell's borders by using VBSCript?
- using a the active cell in a range command....
- VBA script to add text to cell.
- VBA script to delete content in merged cells.
- Can I get VBA script to read a word with both lcase and ucase lett
- Opening Excel workbook via automation doesn't fire event procedures?
- CommandBar control ID help.
- VBA excel using arrays and loops
- save as
- rounding out "time"
- Excel 2007 problem with macros
- userform copy data to more than one location
- Amateur VBA developr seek Professional similar for exchange of insight
- run time error 9, subscript out of range
- run time error 9, subscript out of range
- WriteReservedBy Location
- VSTO Form Issue
- Search a range to find cells containing formulas
- How to know if a validation dropdown exist
- Choosing multiple Series for a XY Scatter (simple?)
- Find ALL WorkSheets according to 2 ComboBox Values.... Help with Code
- Open Access form from excel hyperlink
- Average If statement
- Variable IF statement (in VBA)
- Matching Cell Colors (Cond. Formatting)
- Moving Excel Macro Problems
- Breaking Into Seperate Files
- Concatenate Problem
- Date formatting in Excel VBA Text Box
- Using Shell To Get File Info
- For next loop carries on after criteria is met changing other cells????
- saving email with CDO
- UNC Database Query
- option view (Sheet Tabs)
- Scanning barcodes into a worksheet
- Need macro to autofill when there are blank cells
- Module, create toolbar/handle clicks
- help! user form issues; can't find subroutines; appearance issue
- can I use a pivot table and update my source data (like Hyperion)
- Loop without Do error
- returning the activecell's page number
- How do I set data validation in VBA
- How to access muliple tabs of sheet as variable of an Array
- Variable in function problem
- Problems During Load (XML file Open)
- Auto Grouping of Option Buttons
- Macro Fault - Excel 2002 sp3 Portuguese
- how to receive data through textbox and save the same in excelshee
- Email Hyperlink
- excel and data access
- Text alignment in a cell from VBA
- odd sort issue with numbers
- web query data
- Combobox: Make "Enter" = Select
- Move Selected Rows To A Different Sheet
- Activate cell in column B after performing Find
- Sorting By Largest Value In A String
- Need syntax for RUNning a Word macro with an argument, called from an Excel macro
- rearranging data
- Advanced Filter Error
- Help needed replacing multiple cells from a list of values.
- Print pink sheets
- Type Mismatch!!!
- Open workbook macro if time is between???
- How to extract email addresses to new column
- trade tracking
- Excel 2007 Conditional Formatting
- Faster way to code this
- Trouble with Code to change sheet name
- Numeric Userform Help
- Character Locations in Strings
- Combobox: Autoload property: WTH is it???
- Running Macros
- ListObjects.Add error
- Database Connection with Informix using VBA
- "Subscript Out of Range" Errors For Ranges
- refEdit and Excel crash
- Ignoring comma when creating validation lists
- Hyperlink in access from excel code
- Send Xl Cell info to Word
- Placing buttons etc on userform
- Macro for Counting the number of records in a worksheet
- Listbox not refreshing on update
- Pictures.Visible question (after adding many pictures, they stop disappearing)
- Remove 0D0A from cell with word
- Print Refedit range?
- Use excel vba to Call macro from Access
- renumbering a column
- Save/Load txt files UserForm question
- Assistance please. password on opening excel file
- Please help! Copy sheet to another sheet from cell value
- Automatically Saving A Workbook
- Type Mismatch: array or user defined type expected
- fill down multiple cells in the same column
- Saving and searching Macro
- rename cells with a macro
- Automating a workbook ???
- Automating a workbook ???
- ultiple if Statements
- Function
- finding which cells changed after a calculate?
- Force to enable macros
- "Frozen columns"
- Runtime error 1004
- How can I refer to the ActiveWindow
- R/T 1004 Error
- Excel11.xlb
- calculating values based on text in other sheets
- Move shape, object, pic to center of new cell based on cell value
- Increase columns with interop
- how to trace through VC++6.0 code which is called from Excel 2003 VBA
- Easier said than done
- Changing background color when changing value
- Exclusive choice checkbox
- Automatically copying rows
- check/uncheck a checkbox
- Replacing cell ref with active cell
- Formula should retain
- Help Plsss
- Workbooks within workbooks
- Remove blanks
- Multiple IFs
- Excel Automation : numbers Copy/Paste issue from VB6
- Userform- Formating numbers in Textboxes
- Looping a macro x times(x being activecell.value)?
- initials + increment
- Copying parts of sheets
- VBA CODE: consolidation of excel sheets
- disable control
- disable control
- Indentifying the last row in a sheet with data in it rather than formulae
- Changing Sheet("Name").Select Name
- macro to delete zeros and formulas
- Use a macro to merge cells in a column that are the same
- Copy to next empty cell in another workbook
- Linking to Excel
- Connection object vs. Opendatabse on Databaseobject
- Dumb question
- Replacement or deletion of data after filter
- how to link to DB to update data?
- breakeven formulas
- Change a row of headings based on other selected cells
- Return top 3 occurances of word in list
- Rename closed workbook
- Selecting Just Data
- Date formatting cells w/ VBA
- Date format changes...
- Page Breaks based on cell data
- 1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.
- Convert IF formulas to their values
- Convert numbers (numerals) to words (text)
- Simplifying my previous Request for Assistance
- Resize DataForm
- Removing All Formulae From a Workbook
- Pivot tables macro
- Excel and VB.NET Help!!!
- Invoke Java from Excel
- Excel and VB.NET Help
- Problem writing formula
- DSN Connection with OpenRecorset
- excel, visual basic and serial communication
- adding and copying rows
- import data (html files)
- Using Redemption to email cells with Ron's mailing code
- closing subroutine
- Adobe PDF ActiveX : shame on Adobe..!
- Updating Linked Data in Excel
- Problem with code for merged cells
- Rearranging columns
- Contents of Excel11.xlb
- Trying to run macro on the BeforeSave event
- Execute Macros from Other workbooks on current workbook
- One sheet to another..
- macro problem???
- Compare 3 lists
- How do I create a form based on a list using vba in excel
- How do I do? A personalized form, similar to Show data Form
- Automatically Creating Worksheets
- Deleting rows as if there are no qualifiers!~
- Temporary file open; not visible at all
- One IF, Two THENS
- Inserting Rows
- Limit Find to a single column
- Hide Columns Based on Condition
- Hide Columns Based on Condition
- Where am I
- Return codes from called macros
- Script Newsgroup
- Publishing Excel Macros to Web Pages
- Error Creating Chart
- In need of a formula
- using code variable to write cell formula
- Excel desktop shortcut to cmd button in worksheet
- Create programmatically list of combinations for choices from data sets in excel vba
- Changing Sequential Object names
- One column to multiple columns - with a twist
- One column to multiple columns
- Type Mismatch error - tried .text & .value
- Object Library References not transferring
- Error with Calculating date difference using TODAY()
- Cursor change during code execution
- Open Word From Excel, Different Actions
- VBA Script to search for a specific cell - Help needed
- Log when cells are copied
- Can anyone help finding two obscure commands?
- macro for rearranging data
- inserting columns, writing in cells
- How to get a tick in a drop down menu
- Get Properties Of Closed Workbooks
- Filters
- Populate Combobox with Pivot Table Data
- Correct find syntax
- Can I insert cell values into an email message this way?
- Breaking password on VB Code
- Run-time error 1004 - General ODBC Error
- Use Excel as a network packet sniffer?
- Need some help with a silly error...
- Word document.
- break line in text cell from ASP
- Hidden sheets and macros
- How to del clients fm spreadsheet using a list fm other sheet?
- Automatic Functions?
- Need help with Text to Column in a macro.
- Stacked Graph
- Excel ComboBox / Copy Error
- Excel code for exported spreadsheet
- Macro deleting certain cells
- Format(Time, "h.mm AM/PM") question
- Need Help with Run-time error
- How do I calculate the distance between 2 postcodes?
- Cannot set ColumnWidth past column 148
- Cannot set ColumnWidth past column 148
- how can i create quiries in excel from ODBC data source
- Count spaces in front of text
- Copy Data into Template Worksheets
- Force use of standard function
- how to write excel macro for repeated dynamic data
- Data Validation...A Multiple of a number
- Testing a range for blanks
- Checkbox connection with Macro
- automatically moving data depending on date
- Automatic Updates to Spreadsheet - HELP
- manipulate color with code
- Import Excel data with .NET
- Column number
- live time on userform or within frame
- Column number
- only cells that are colored yellow
- Refreshing Worksheets
- on time macro
- Is it possible
- How do I update without sheet select
- unload userform problem
- paste data in cell after user has defined where
- Need macro for protecting individual rows in a worksheet
- excel runtime 1004
- Paste numbers
- Efficiently Generate 88 Chartsheets
- Simplify Cell Formulas - AGAIN
- need macro for create new email message and send it
- if macro is made disabled.??
- Use of Subversion / CVS / Source Safe
- Find and remove blanks
- Drop down box with associated passwords
- how can vba detect what is currently selected?
- coloring columns in pivot table
- Is it possible
- Userform SpinButton problem
- when to use a module & when to use a project
- several scripts in one single script
- Next without for
- Userform Gallery
- How to calculate: sumproduct / db??
- Is there any way?
- Using FormulaR1C1 to find fields begining with spaces
- Absolute value
- is there not a simpler way
- How to protect few cells of the worksheet from editing?and few other doubts also plz help
- Close workbook
- writing excel
- USE OF DROPDOWN in Combobox-a problem
- excel vba word merge printer error
- Want to connect to Outlook Program; but can I keep my Web Page?
- Protect/UnProtect Project (code) via VBA?
- Enhance your domain skills required for the job
- Multi Dimensional Array
- please help someone (again posting)
- Remove space and "-" character
- Printing Problems
- Workbook_Open() and Object Not Found
- Command Buttons and not Printing Them
- Re: ComboBox Row Source across ALL sheets
- Next Known Date
- userform multitask ?
- ols
- Dependent ComboBoxes as Critiria for VLOOKUP or OFFSET
- Help. Getting error retrieveing version number
- do not allow same data twice
- Options Button for Excel Userform
- Simple VBA question (?)
- Help! Stupid CommandText Problem
- conditional formatting and VLookup
- column and row autocorrect?
- Inadvertent macro
- Split date into Variables
- Workbook_BeforeSave Event
- duplicate data
- Case Selection Example
- Taking multiple information from one cell.
- Excel - how to prevent new office version from upgrading word object reference
- Delete Row Based On Two Columns
- AutoFilling To A Variable Number Of Rows
- How can I activate scrollbars in an own userform?
- Macro - IF command
- Currency Converter From Website
- Date format change
- Copy and paste macro
- moving data
- 2 VBA enhancements
- Paasing Values from one Array to another
- Disconencted recordset for DSN less connection
- Using Msnstockquote from excel VBA
- Application-Defined or Object-Defined Error
- cell name - macro
- View values; ignore header database
- Modification to existing Code
- write in excel
- Auditing Code
- How to exec a commandbar button while cell in edit mode
- Designing a spreadsheet
- How to exec a commandbar button while cell in edit mode
- Frames and buttons
- How to take a range input in a function and find the frequency of data in it.
- Change the line color based on the value selected in combo box
- Excel add-in that may help the color blind
- Frame
- delete contents of visible cells only
- A 64-bit variable from VBA to VC++ dll and back to VBA
- Formulas within pivot tables
- Placeing buttons on spreadsheet
- Having a cell display certain text or formatting when the worksheet is protected or unprotected
- Help with open files
- Locking panes
- Runtime error 91?
- Help with coding please. Newbie.
- Digits after the comma in Userform
- Form
- Is there a way to unlock a project in VBA if you know the password
- Manipulating Text File
- excel add-in write text
- How to write to the VBE of a closed workbook?
- Freeze pane
- RefEdit problems
- Referring to a row or column
- Delete blank sheet
- NickHK
- VBA and Printing
- Calendar Control Addin
- Disable excel message
- Calendar value
- Scrolling a Text in Worksheet
- Calendar value + 30, 60 or 90 days
- Wordart in userform??
- Numerical integration to a maximum value using VBA
- Modifying a database based on changes in an Excel document
- Macro for sorting color data
- Add Hyperlink
- Expression Difference?
- How to run a Macro specified number of times?
- Updating a cell based on contents of two other cells
- ComboBox Row Source across ALL sheets
- Deleting WorkSheets MANY
- Keeping buttons stationary when unhiding rows.
- Setting Default Save Path
- Zip codes and Distances
- Catching an error
- Open Excel with a XML file and SaveAs XLS
- macro for sumif formula
- Copy Excel chart into new ppt slide
- Math involved. Excel speed optimization question. UDF vs. longer excel equation
- Prompt for Action before closing workbook
- Event Change Question
- My macro won't find the last row !
- Check the content of a textbox?
- Find and remove blanks
- Combining the IF and List functions
- "If Yes then Proceed..." Macro
- formula that takes part of a cells contents to another
- Choosing offset on condition found in combobox change colour of cell??
- Syntax Formula help
- Get VBA procedures from DB
- Date format to decimal format?
- Best match macro
- Evaluate Range of Cell
- Macro to Consolidate Worksheets
- Sequence of numbers
- executing macros upon opening xls files
- MS Access Query Identify Friday's records.
- RefEdit problems
- Format Part of Text Cell using VBA
- Pivot
- Dynamic Named Ranges - LINKING
- List box VBA script to clear cell in other sheet.
- RefEdit ???
- using excel to query asp page
- RefEdit ???
- copy unique rows
- msoButtonUp / Down for sub-menu items
- Adding a row on Open
- Pls Help on from date tranfer amount to month
- Adding a row on Open
- Is the list of Worksheets limited to "This Workbook"
- UDF sharing
- Newbie needs help on excel formula
- Changing format of cells
- query result through array on worksheet
- steping through all cells
- compatibility to EXCEL transformation
- Changing format of data
- Chart size
- how to execute a macro automatically
- Teaching Sub-Levels and Excel Nightmare
- UserForm
- Excel Icon??
- Filling TextBoxes
- Linest(known_y, known_x^{1,2,3)
- Copying and Pasting Using Row Counts
- pull rss feeds into excel
- how to use FTP in VBA
- Combo Boxes
- where can I find the trace precedents button on the toolbar
- Macro to "archive" cells
- Replacing macro buttons with a new set of buttons
- Textbox: Number of Characters
- peculiar error with Range() object
- Detecting abnormal values in a moving range.
- Searching array for date and changing offset colour depeding on combobox content?
- Problem with a converted office 2003 file with user defined functi
- company calendar: start date problem
- How to repeat a macro
- Modify Yearly Calendar to Monthly Calendar Excel 2000?
- R/T Error 1004
- Adjusting individual icon size in commandbars?
- Excel experts needed
- Converting data from row to coulm
- Transfer data as per there date in there month.
- Error trapping
- Sending Mail using VBA
- Row number of a specific value
- Using COM objects in Excel or VBA?
- protect formula
- Loop with Time
- Calendar Control
- printing macro,want to use beforeprint event?
- Grouping objects
- Printing labels from names and addresses in an excel
- is sheet protected?
- Window>Arrange>Tiled - all xls in directory
- Linking and embedding question.
- Sheet protection
- Trouble with lots of IF THEN statements???
- How to create a Delete method which frees memory occupied by my object
- How to find an excel sheet by its name???
- Custom button to call a macro in Personal
- Can't get the find statement to work correctly
- Last Row In Column..
- How to format userform label at design time?
- Making changes to most worksheets?
- string variables in file names
- Problem with macro speed.
- Basic VBA Question with Array
- moving xls files with macros to another directory?
- Command Button from Control Toolbox
- How do I stop the SQL Login screen when refreshing a query.
- Use of sheet codename in codeline - How?
- DATE
- Setting "r" to = range selected in an IF statement?
- Spellnumber Function
- COMMANDBAR MANIPULATION....
- Web Querry stopped working
- HIDE ROWS IF..
- commandbar scope
- VBA Code--------!
- ChartObjects Macro excel2000
- If staement and macro
- how do you create custom buttons in office 2007?
- VBA Help required..........!
- Import tab text data(more than 65K rows) into excel by VBA
- find and highlight
- Convert an Excel table to a list with VBA
- Save button
- listbox.value is empty even though there is data!!!
- How to automate with macro multiworksheet File using array variable?
- "On Error GoTo" syntax problem
- macro to open csv file on the web with password
- not your average activate event
- Retrieving data from Web page 2
- Right click event
- Formatting numbers in a text box
- how to determine if user has Outlook or Lotus Notes
- VBA versus Scripting
- Community versus Newsgroup
- Remove object from memory
- subroutine variable decleration issue
- #N/A in 150 WS
- reading data from thumnails
- Cell/function manipulation
- Pic Macro
- copying all of a row & Attributes
- Wrapping text in an Excel Interactive Web page
- Macro Code required..........?
- Counters
- protect Micro
- Macro in body of workbook. Can I create XLA?
- Copying Formulas Down Rows
- Getting 0 to not equal False
- .Precedents don't work in UDF
- Offset with variable?
- Offset with variable?
- delete rows with dates between
- Filter for 4 criteria only need data from one column
- Error when deleting rows
- Explicitly passing a .value
- Formula to Excel VB
- Transposing time series data
- Linked Workbooks
- Exporting to Excel
- Finding the right column
- Windows version language and Excel version language
- Help with storing data
- Dir command not consistent
- UDF Can't return more than 255 chars???
- Vlookup
- Please help
- Dictionary troubles. Declaring and checking .exists
- Need Help
- Validation List
- Transposing time series data
- How long do variables retain their values
- 1D Array Problem (Subscript Out Of Range)
- Fastest way to get keys from collection
- Hidden cells
- Considering Holidays
- Data Import ODBC at 30min intervals with Macro trigger
- Run-time error '1004': Unable to set the CategoryNames property of the Axis class
- Run-time error '1004': Unable to set the CategoryNames property of the Axis class
- Run-time error '1004': Unable to set the CategoryNames property of the Axis class
- Need help with Lookup
- Object Variable with Block Variable Not set
- Re: Initializing a dictionary and then modifying it.
- Add a second condition to loop
- Compile error in Excel
- Excel VBA's are there but not recognized as macros so they can't b
- Copy and paste row based on cell content
- opening multiple xls files in a folder
- Initializing a dictionary and then modifying it.
- Need to get modified date
- Need help with changing data after it has been imported.
- VLOOKUP
- Programming Cells To Change Colors
- Standard length of a line of VBA code?
- Shell for Outlook
- Problem with Auto_Open function
- Chip P.
- Problem with Auto_Open function
- SUMPRODUCT statement only works sometimes
- Record the date on which the record is made
- pictures in exell
- Run-time error 1004 Method "Range of object_global failed
- Multipage Part of Form
- Printing a Background
- How To Maximize A Window From The Task Bar
- Form
- SpinButton1.Max quick question
- Opening a word document
- No 'Click' for CommandBarPopups, so what should I do?
- How to make a cell containing a macro call to be recalculated?
- Macro for Drawing
- Elastic array
- Macro to insert copy and insert formulas only to next blank row
- Control array
- Counting worksheets with a particular name
- AnyOne !!!!
- How do I add a button to an excel document?
- Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
- LadyHawke
- Execl VBA
- How to stop all Excel funtions for a period
- An old question about Office 97 to Office XP upgrades and Bloomberg
- problem with calendar dates format
- Irina
- This simple userform is driving me nuts
- Ending session
- Window Object - Subscript out of Range
- Detect # scrolled-out rows and column
- EDIT>GO TO...>SPECIAL...
- Syntax error..
- User defined chart
- I need some help with userforms
- Code to modify find/replace
- Need syntax help!
- Disable the alert
- Help please
- How to find Windows login name with code?
- The same IF (SE) formula give me two different number: why???
- how can i perform interpolation on a data set?
- Userform loses its capabilities...reset???
- Check to see if a file is already open
- Treeview Question
- How to programmatically test whether VBA code exists in an Excel file
- VALIDATE WB NAME
- Coding to make a transpose values button
- need codeto view the 56 colors of ColorIndex
- public function to sum input and return total sum + 10%
- autofilter syntax in VBscript
- IF formula with correct formatting in result
- Quick Question on This Code
- Event Procedure (re-activate automatic calulation if disabled)
- Toggle FIND criteria
- Newbie VBA Problem
- CommandBar 'Insert'
- Highlight duplicates
- a sensible, descriptive name for activex
- Saving Changes to Excel App
- macro as and moving files
- Hex to ASCII converter in Excel?
- Controlling Outlook 2003 with excel
- Triggering UDF
- DATE Formula
- Lotus 123 to Excel
- Importing Text Files of 100,000+ lines, many blanks
- How do I build an excel query? (something like SQL)
- Capture AutoFill...
- UserForm to Hide/Unhide Rows
- ComboBox Lists
- Crystal xcelsius
- Retreving data from Web page
- Loop & Cell Reference
- Using a formula in a SUBTOTAL Line
- In excel can I display a cell based on a calculation (eg M(14/2)?
- Error 424 Object Required when passing range as parameter
- Problem Naming Worksheet
- Is there a way to WAIT in Excel without using 100% CPU?
- Code to show a graph
- Validation of cell results
- String Array initialisation
- Filter Macro with Cell reference
- choose default macros Not Enabled / Macros Enable Setting
- VBA select default Don't Enable / Enable macros Setting
- VBA function got name error in excel 2003
- How to print fitted 1 page width and 1 page tall
- Adding Number
- Restricting copied text to one Column
- MKDir not working
- String array initialisation
- Assign my own sound from a list to a command button
- Referencing code outside of current sheet
- Dictionary and saving workbook/ reopening
- Hideen Worksheet
- Mouvement macro
- Locking a sheet & Menu Items
- saving changes
- Variable Decleration
- random dates showing up in userform
- File properties (size date)
- Missing Help Files
- Printing selected pages in a Word document
- Do loop error while using FindNext command
- Macro to send email through Lotus Notes
- Problem with ListItem Width
- General Mail Failure for "ActiveWorkbook.HasRoutingSlip = True"
- how do i add weekly averages in excel
- Adding a counter to ranges
- Trouble with dynamic named range
- Combo Box - auto complete and the bound column/text column propert
- Email From Excel/VBA
- veenob3.hlp
- Creating Variable for a Sheet
- Find Last Value
- email in XL XP
- Insert & Sequentially Number Column
- unable to record macro
- Type mixture error
- code help
- Sheet Name to Cell Value
- Print macro
- To block "to "eliminate" of the picture of form, information
- update all the pivots at the same time
- calculation semi auto?
- Save a single file webpage of each visible sheet in a workbook
- Reg : Excel
- set up multiple prices for drop down list
- Inputbox Default to be Upcomming Sunday
- dynamically assigning QueryTables.Add.TextFileColumnDataTypes
- Default Transparent color for bitmaps on cmd buttons
- How to loop thru cells in a row
- Userform loses its capabilities...reset???
- To block "to "eliminate" of the picture of form, information
- Call VBScript from VBA, pass variable, return result to macro?
- Incrementing a field
- Array data to Range: Only first value written
- Date Comparison
- Shapes into List Box
- will 2007 multithreading capability help the vba<-->worksheet tran
- Combining two sheets into one
- highlight with right click?
- How do I set up macro to truncate column/field?
- VBA: Date Comparison
- Chart placement
- VSTO Excel -- Urgent Help
- Create New Wk
- Custom properties not showing the value when set programmatically
- Opening Workbooks in a Folder
- Macro help required.Can any body help.........?
- Inserting a text character via a menu option into...
- Macro help
- Automatic File Download using CuteFTP
- Can anybody help on Vb Macros please..?
- Can anybody help on Vb Macros..?
- RTD wrapper functions do not work in Excel 2007
- Replace fuction replacing all instead of selected cells
- Is MAPI or CDO installed?
- Circular Reference?
- Count backwards
- .ext file
- Can anybody help on Vb Macros..?
- *.csv to *.xls
- Setting size
- Making charts
- Changing color of tabs
- how does a macro use an inputbox ?
- How to stop Excel from animating range selections?
- Macro to add a combobox?
- Charts
- Search Goto Feature
- Logon Dialog prior to Open Database connection
- Change combobox properties
- Theuns
- Theuns
- Small problem with GetopenFileName
- Placing charts
- Making charts
- Speeding up macros
- Error while populating a combobox from Access database
- Changing color of tabs
- New WorkBook Macro Looking to WRONG WorkBook
- MouseMove & Click event over an image control
- runtime error 75 when I run the application for second time
- XP question
- How to simulate "Data>Form" in VBA
- Can't find Project or Library
- To block "to "eliminate" of the picture of form, information
- Array? IF? LOOKUP? VBA?
- VBA and Displaying Chinese
- VBA Function won't work!
- different between CreatePivotTable and PivotTableWizard
- PivotTableWizard using SQL Analysis Services
- Problem with Macros!
- Add value when checkbox is ticked
- excel applicaton closes showing complietime error not allowing to edit
- Compare two workbooks and Copy missing data
- Screen Updating on Open Workbook
- Conditional Format
- Handling the 'Cancel' button..??
- Table with Excel
- If/Then
- Question related to Recursive Formula Execution
- Field Data Validation in VBA Forms - Here's a way
- Advanced Data Maintenance Dialog Question
- sql string, +'/'+convert(char(3)..)
- 2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
- Help with List Box
- Swapping two ranges
- Reminder Emails
- Opening Outlook and PDF from excell
- Summary Page
- How to send HP printer escape codes from Excel?
- OLE automation with PivotTable and external Data Source
- A way to simplify this please
- Help with Advanced Sorting Macro
- keep column's information consistent in different worksheets in same row
- NEED a PRO: Screen Epilepsy
- Using Excel as a data base
- Find next blank row
- Macro: Convert to PDF & E-mail. Possible?
- SelectionChange and Pivot Tables
- ~~ Help with Userform and Combo Box ~~
- Replace left header
- Merging Worksheets
- PrintToFile from spreadsheet
- How to skip "unrecognizable" msg when opening Workbook
- file name on worksheet
- VBA Coding: Date Consideration
- Set Column Width Based On Total Width Of Other Columns
- Working Days
- Looking for faster way to find minimum value
- selection.value <> "A list of values"
- Pivot Table Data Connection
- Save as cell with path
- Can't get Application Events to work with .xla
- Incrementing Cells with Macros
- Using a Sheet Name
- Select all cells in a column up to a blank cell
- Using row() in conjunction with a column number.
- VBA Loop Excel Record Extraction
- Unable to set the locked propert
- How to Get Excel Command Line Programmatically
- summing a range in a UDF
- Sort Multiple Sheets by Category
- copy duplicate rows to new sheet in WB
- How to split the active sheets into two different work windows?
- macro to delete on a condition
- How to capture autofill?
- Finding Last Cell that Has Data
- Summary Page
- Access transfer to Excel
- Removing quotation marks in a txt-file
- Open Outlook from userform
- Assure entry is numeric
- How to use PivotTable as a source of selection?
- Calculating a growing formula
- Save As Macro
- Control for selecting cells in worksheets
- Loop that Copys from one sheet and pastes to another
- Check validation on SelectionChange
- How does one create a delete property of a user defined class?
- Import Problem
- Need help using a toggle button
- Find/Replace Macro with format changes to the replacing number
- How to read DBCS from a cell in VBA
- Need an Excel VBA script written
- Identify duplicates and move to new sheet
- Find value in bottom cell in a column
- VBA Loop
- Data Validation Returning only distinct values from a list
- ChartObjects
- Saving Excel as latest version
- Placement of charts
- Automatically transfer cell contents
- Identifing Locked Cells
- Removing a collection item via key name check
- Paste Array to .xls : All at once
- Updating data from one workbook to another
- trying to find #REF! in a formula to replace with a sheet name
- Help with using ADO to connect Excel to Access
- Searching for exact text
- Using Active Cell Value in a Calculation
- Copy Paste Macro
- event after worksheet unprotect
- CopyFromRecordset Error If More Than 911 Characters
- Converting number to text
- From cell/combo to combo/cell
- SUM in VBA
- "Automatically" get name of selected autoshape into formula? Impossible?
- Cannot destroy Word Object in Excel
- Copying Data Between Two Spreadsheets
- inserting colon
- Recursive Loop -- How to Stop It?
- Calculating Rents and Months past in 1 cell???
- Get, Set and Let
- Counting rows in a range
- Name of month
- Passing references
- Pivot name changes automatically
- Making worksheets
- word files with embedded excel objects
- Macro to paste row number in cell
- Bring up an error message
- How do I add a search box
- Re: Pausing macros
- Add-in Description
- Printing a Userform
- Loop help
- How to save the option button value
- London Excel User Conference - Register now, it is not too late
- Need help with an if statement
- Cell adress for next non-blank cell in a range?
- slow macros
- Forcing user's to use the most current workbook!
- Re: Forcing user's to use the most current workbook!
- Summary Worksheet with VBA
- ComboBox ShowDropButtonWhen error
- Select columns of active cell's row
- A couple of questions (formating & Collating worksheets)
- Named range in a sheet referred to from another sheet
- autofill method of range class failed
- Addition of a macro to an existing Excel file
- get values from combobox in excel.
- read string from database and divide result into cells?
- Saving Protected Workbooks
- insert row on next sheet
- Secure Macros
- SelectionChange stops working
- AS400 copy problem
- Creating a macro to open as save other selected Excel sheets
- cocatenation
- check cell for #REF!
- Compare strings in cells and highlight difference
- CMD prompt output
- Selfcert.exe cannot create a certificate
- Keep text color
- an earlier post
- Validate WorkBook name
- Excel 2007 vba question
- how to make this in Excel...
- Application.Dialogs(xlDialogSaveAs) = res ???
- Hide Rows By reference to a cell
- How to save compiled version of VBA macro
- Hiding rows bt reference
- Programmatically defining dynamic range
- Data Validation list in Input Box... Possible ?
- >> Defining a range
- help with IF statement
- Dates
- Require some codes for variable in formula
- Create Calendar Wit Data Auto Fill using Excel 2000!
- Altering code to accomodate empty space
- Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...)
- Graph Source Data
- Use a button to copy the values of one range to another
- help creating helper column
- Sub that has an input of an array of ranges... what's wrong?
- Paste Append?
- Flash a label
- Open Hidden sheets to specific point
- >> Listboxes on a worksheet
- A class with two objects?
- Conditional Formatting 4+ conditions, format rows based on cell
- Close All and Workbook_BeforeClose events
- Unhiding all worksheets
- Unshimmed Automation Addin and Shimmed COM Addin in same App Domai
- prevent a special cell from being deleted
- lookup
- Protect sheets via VB6 automation
- Application.Transpose in VBA EXCEL 2003
- Single Macro containing multiple subs
- Volume Calculator - Button
- Filter on cell value?
- Validate Workbook Name
- Little Macro help
- Can I use a cell reference to provide a value for a scenario?
- Conditional Formating on Worksheet Change
- Auto Load an Add-In
- Print Format
- Using Currently Open Lotus Notes Mail Server Info in Excel Macro
- Merging XLS Files
- Select sheets based on what is in a range.
- Re: I said "Keep this text! Not a date!"
- Re: I said "Keep this text! Not a date!"
- find duplicates between rows, keep or delete entries based on ranked relevance
- Userform initialize combobox using Chr() function.
- Searching Database
- Countif
- Cleanly Trimming text...
- Calculate event using chart data
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.