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 |
- Re: Group Names Change Upon Paste, Kills Code.
- Excel VBA - User form caption problem
- Re: ColorIndex
- Re: ColorIndex
- Re: Group Names Change Upon Paste, Kills Code.
- Workbook_Open Event
- Re: Auto Freeze Frame
- Re: Edit a userform
- Add another range
- Pass parameter to a form and then open it?
- Re: sub directories again
- Detect event if excel is in edit mode.
- Code to clear sheet
- Identify strange character
- Edit Text in Button
- Re: two... two... two questions in one!
- vc++ automation: opening chart as chart window and setting scale
- Filename and creation timestamp in 2-column combobox
- Help Transposing Data from Row To Column
- Re: Charting Weirdness and VBA
- Excel formulas efficiency
- Auto Hide
- Controlling Text Loading
- Re: HELP!! Macro suddenly not working
- NESTED IF
- PlotArea.Interior.Color ... all white
- User-preference Customizations in Personal.xls
- sub directories again
- Spreadsheet object
- Making a function available in all sheets
- Finding a Linked Cell
- Merge and Sum Tables
- Conditional Formatting help...
- Printing -
- matching and formatting...need help!
- Save in location button
- Create button with addin/reference macro in another file
- Excel VBA - Worksheet Coding Help
- Using a form to input data into a schedule
- Workbooks in use
- Repost: Smart Hyperlink
- Protected Workbook Opens Restored
- Keeping multiple sheets synchronized
- Import data, calculate, export data
- Question about IIF in SQL query
- How to set up an automatic SUMIF function
- Sending text from a Text box to a sheet
- Data Transfer
- Help!!!!
- Q: References: upgraded office, library changed causing errors
- How to pull in 2 different rows and compare them
- Menu Items and Disable/Enable in Excel 2003
- entirerow.delete multiple text conditions
- Printing during select times
- Sorting Columns using VBA
- Creating Password
- Events for Controls in a Multipage Control
- Invoke Outlook Express SendMail From Excel VBA
- Why this simple macro doesn't work?
- Copy to windows clipboard
- Worksheet name
- Buttons
- Search List of Data
- Consolidate User Input
- Macros
- Worksheet protection order
- ListBox
- Making a macro with random placement.
- excel--->access
- Turning off circular reference warning
- Attaching text to button
- Loading an Excel file
- Help Again with data comparison
- Delete names in workbook
- Public/Procedure Variable
- selecting workbook/worksheet from browse button
- Making an active cell the first one to appear on the spreadsheet
- Re: Custom sheet protection
- Excel 2003 and Macros from Excel 2000
- All cells not calculating
- Different passwords to separate ranges in excel 2000
- Linked ListBoxes
- Clipboard
- Rounding Based on Value
- Debug.Print
- Excel VBA - select firsty 30 characters of a cell
- Sorting lists of Named Ranges
- Formatting userform textbox - help required
- MultiPage control
- Adobe using VB
- Re: How do I create a combobox???
- How to specify a range in Excel macro
- Re: Refresh a PivotTable using VBA (SQL generated Pivot)
- Hiding all Toolbars
- format +44785656656 as text
- Using Countdown in Status Bar to Play Sound
- Excel Headers
- Sending Email Notification of a completed VBA process
- Keep multiple sheets in synch
- Running Code on Each Sheet in an Excel Workbook
- Excel VBA - Searching long words
- Excel VBA-How to open several delmited files & SaveAs Excel files
- VBA Forms
- XL97 - Apply colour to Pivot tables
- Problem with Format statement
- How to connect to Informix database using ADO???
- XML / XSL security problem
- rows().value
- Closing workbook
- CreateObject("Excel.Application") -> Access denied
- Can I rename a directory using a macro
- Protect Workbook
- TIME values
- Fourier analysis
- Sort data
- How to activate a file when the filename is represented by a string variable
- Number Validation
- Formula Palette
- Help!
- Create CommandBar in xl95 code - possible?
- Q: is this continually looping?
- email
- Excel 2000 drillthrough
- Customize CommandBars (disappear and reappear)
- Reading from ini file
- Using a listbox effectivly
- Adding to a named range on another worksheet
- In theory Excel vba work out a roster by itself
- Virus in my Immediate window?
- Error trap with object variable problem
- Application::DisplayAlerts not working
- Counting blank cells
- Resizing an image file
- Code works 1st time then Type Mismatch when checking for not blank cells
- Change date format
- Excel VBA - Problems using Protect/Unprotect a worksheet
- Summary of all worksheets
- "Assign Macro" is gone from menu
- Time Clock
- save file name with Chinese/Asian
- Drawdown Analysis
- Help With Runaway Calculation
- Saving a Favorite from code
- Open workbook without update all linked information
- writing on cells
- "Harlan Grove's resizing code",
- RE: Copy with criteria
- Please Help me
- GetOpenFilename
- Extract 1st word and in capitals
- VBA Array Population with a Single Line of Code
- GUI
- Largest value in a range
- Can Not Find declared dll
- Missing library?
- combo box
- DDE Argument exchange with Word
- open file
- Delete Selected Rows
- Open two text file in Excel
- Applying Macro to all workbooks...
- autoselection in a pivot table
- fast way to make reports from a database
- =IF in VBA
- Excel VBA-How do I increment columns in VBA?
- Re: Hash (MD5) in Excel
- Stutter in AdvancedFilter Unique Results?
- Excel Validation / Dropdown list Problem
- Filtered data selection using vba
- How to add line at today's date in chart
- Need help With Code:
- Button Error - Save at location
- Icon change
- Simple copy paste question
- Color Index and RGB Color
- Re: assign number value
- change background color of row until condition is met
- Changing caption text and hiding buttons
- Indirect function - relative reference
- excel column only numbers
- Popup Menus
- Re: Hyperlink to execute macro.
- Re: assign number value
- Macro skipping blank cell
- Re: Help! Calling hidden sheets?
- Excel VBA-How do I increment columns in VBA?
- Re: Excel - Calc current age of a person
- Re: Help! Calling hidden sheets?
- Automatic creation of an overview using several workbooks
- Re: Excel - Calc current age of a person
- Re: Help! Calling hidden sheets?
- Subscript out of range
- Run Excel Report on Server w/out human interaction
- Worksheet Controls
- Excel XP XML macro security warning
- Parsing out text entries in a text box
- Re: cell reference in formula
- RTD UpdateNotify()
- Re: cell reference in formula
- How do I: prevent user from scolling down and right?
- Re: cell reference in formula
- Is variable an integer?
- Reselect cell after macro
- Re: cell reference in formula
- Import table into new sheet
- Re: Just a tip I have picked-up
- Command bar Defaults
- Excel VBA .NET?
- UserForm Question
- File Browse Box
- Re: extract with criteria
- Use of Drop Down -- A New Beez question
- Enter pressed in Textbox
- Copying cells
- Re: Calculation involving Time format
- easy problem
- Select Case Information Needed
- Trigger macro to run when picture is deleted
- Open a Word Document
- Excel 2002 and startup
- TrailingSpaces
- Disabling Events
- Excel VBA-use variable in active cell formula problem
- Error -2147417851 '"The server threw an exception"
- Pivotfields.CurrentPage
- choosing from a list in VB
- Getting HyperLinked Cell to Appear at the Top of the Screen
- Setting width and height
- change caption font color at runtime
- What 's wrong with the coding? -- about using outlook to send attachment in excel
- Add column to left of "hotspot"
- Re: Hash (MD5) in Excel
- Importing from MS Access
- formatting
- Adding Validation (drop down)
- Help on writing a code to copy and amend lines
- extracting matching data
- run macros on a protected sheet?
- Slow VBA, Can someone please look at it?
- Delete Sheets
- v.basic misc programming ?
- Customized Menu Macro with Argument invoked twice
- Excel-Web Queries
- re-entering userform
- VBA Code needed to start different public sub
- Sheet to Workbook
- access-->excel-->access
- Return all page ranges in an array? (Repost - Tom?)
- A Word Problem...
- Moving Chart Objects
- Text Import Wizard
- Network printers, how?
- Visible property on Worksheets
- Positioning Data / Form dialogue box
- How to highlight cell match todays date
- MD5
- Update
- running windows system commands in VBA
- Web Query - No data
- Logical or
- FILTERING PRICELISTS
- how formatting CSV file to get alt-enter text in one cell
- Autosaving
- Exotic CheckBox
- excluding a value in a max determination
- Files in a dir
- Closing files without save
- Timer
- HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Re: Type mismatch
- seperate contents of a cell to two cells
- Cell Reference- Hiding Rows-Urgent
- Activeworkbook.Saved
- Limit worksheet navigation in Excel 2000
- Create new workbook
- Re: Excel VBA - Opening Files
- Help... This code consistently crashes for no reason.
- Cell/Variable content substitution
- Starting Excel from cmd pmpt, pass parameters
- Copying Range
- Removing dashes in entire column using VBA
- Re: AutoSequencing in a New Worksheet
- Open image from web in window same size as image?
- Fill emply column with formula
- forms and reports
- stock control
- Copy and paste selections and formatting to new worksheet
- Need help with a macro
- cell reference in another workbook
- VBA creating Pivot Table
- turn $12 to $12,000
- Cannot loop through rows in C#
- Combo box
- Changing Freeze Panes as I scroll down
- calculting stats of column array in 3D array
- BAR CODE Instruction
- Error 1004 in printing .ps (postscript) file from .xls file
- referencing a sheet in VB
- How do I sum across rows in a macro? SumIf?
- Opening a Workbook
- Copy recordset from an Access "make table" query
- VBCodeMod crashing Excel
- Export to Excel
- Making your UserForm print other workbooks
- Saving file without macros
- Removing Command Button
- Combining two arrays
- Progress Indicator in form
- Thank you re VBE Windows problem
- Populating a Named Range...
- Macro Security
- creating unique new worksheets
- data entry...
- Re: Property Set
- Can I turn off roundup automatically for a cell?
- Random Text
- Capturing Screen Size Help Needed!
- "IF" "AND" Functions
- MsgBox Question - HELP!
- Re: Type mismatch
- Run-time error 2147220960(80040220) mail with outlook
- Seperate with space
- Formula help please
- Format a header when using Range()
- Chart - Title Widths
- writing a formula in VBA
- Further Split-type help, please
- Configure Combo Box to Show Unique List Values Only?
- Iterating through workbook capturing text
- How to Unhide and Use Columns to the right of the worksheet
- Toolbars
- Radio Button Selection in UserForms
- Macro Library
- Downloading full pages to specific targets
- Printing problems
- Return an array of all page ranges in a sheet?
- CATO file import to Excel
- Selecting a PivotItem in code
- Autocomplete Possible?
- problem using Set statement to define range object
- VBA - Immediate Window not docking
- .xls file keeps referenced addin(.xla) filepath?
- Can I "compile" VB into an executeable program?
- Macro to Color Code Cells
- Clearing Collections
- Allow access to visual basic project
- add macro to wksht
- Adding a new Line
- Deleteing Rows
- Passing parameters
- CHANGE QUERY SQL CUBE FROM EXCEL
- Could not find installable ISAM
- Cell value in a formula --> Indirect function? Help please...
- Activating a modeless form
- Conditional Formatting to Validate Data in multiple worksheets
- Recursive Subs?
- RePost: Summing column in 5D Array
- Show All PivotItems in XP pivot table
- Excel template file, where is it?
- Data ranges
- Open As Readonly
- Disable Page Break Preview Button
- xp shell command using vba
- VLOOKUP return - #N/A
- Create/Remove toolbars
- Application.Run Method
- Out of Stack Space
- delete folder
- Use a cell with text on it as part of a SUM formula
- Excel VBA - Help with a loop, compare, delete problem
- Date Functions
- Macro Size Limit / open macros with macros?
- Copy data not format
- Extract parameters passed to a function.
- Dependents on another worksheet
- time conversion
- Date Update
- combo box not working
- Use excel in html format change the links
- .select efficiency
- Procedure loop limitation?
- I need help with a macro
- Reference names and hyperlinks to other files in other directories
- Now sure how to get data from another sheet
- excel macro
- Sorting algorithms used in Excel
- Plot data on map
- CopyText
- Att: David McRitchie
- Control Toolbox vs Forms
- find existing worsheet
- Userform idea
- Format Cell Content
- Help! (I need somebody)
- Problem with decimal number smaller than 1
- Non programmer needs calculation help!!!!!
- Switch To/Retry message appears
- .NET dll
- function wizard access violations
- Textbox formatting
- VBA: Finding duplicates in Change Event
- offset function
- Autorun a macro
- HELP - weird Negative Numbers
- safe protection of sheets and vba
- Command button
- Open data
- Custom cell formula
- how to run VB with excel chart at PC without Office2000
- Copied shapes are some times oblate
- Documentation
- PivotCaches.Add
- Blogs, sites, books, sample code, Excel+VBA+Finance
- Subscript Out of Range error in Array...
- Shared Workbook - insert row and keep validation & format?
- custom toolbar loses settings
- Create workbook for data export and then data import?
- protect formats
- nesting problem
- Error 40036 when activating a sheet
- Optional Arguements for Functions
- Updating entries on a spreadsheet via Userforms
- Extracting nth element of X dimension
- Sorting 2D portion of 5D Array
- subtotal with median
- excel 97 crash
- Excel Macro
- Two Questions...
- time keeping
- VBE Options
- keep the VBA modules in Excel transferable among different computers?
- Revisited: If Cell in row has data then do this: HELP
- Sum Multiple Columns with Macro
- Re: Custom Data Sort
- Copy entire Worksheet how?
- Custom Data Sort
- BROWSER
- Cancel Button
- Re: If Cell in row has data then do this: HELP
- Limited help from err message
- find last row on a worksheet
- Date Validation?
- Button - Save Location
- Macro
- SUMPRODUCT help, please?
- error control
- Add-In communication with outside Application
- Excel VBA - 3 Problems (Yes/no box, Password Box, Run Dialog)
- ADVANCED data strippping
- Form Textboxes
- Accessing a single worksheet in a workbook
- Copy Sum Rows to Totals Sheet
- Remove CommandButton
- control box
- unblock .exe attachments in outlook
- I need a macro that copies that data from one cell on one sheet to a cell on another?
- Chart - Title Widths
- import from txt file
- Hyperlinks
- Re: Adding Time
- Call a proc inside itself (HELP)
- Copying data from one cell to another
- Populating Third Dimesion Based on Average of three elements of Third Dimension
- Re: Arrays
- Toggle Acrobat add-in on/off
- Counting Days Between Variable & Fixed Dates
- Fancy Object Declaration
- Excel interpreting HTML and CR/LF
- date column
- Using Excel to handle Com callback procedures
- Cut & Paste Loop
- VBA code for set print area
- Macro for Multiple Sorts
- change font size and bold in cell?
- dynamic buttons
- Linking together data from Eeevvverrywhere...then printing it
- Showing plus sign on positive numbers
- Append from Excel 2002 to SQL
- Error Message..."No more new fonts may be applied in this
- Linking cell
- Printer Driver Function
- list box
- Array Join & Filter funcs
- counting column elements
- Append Excel 2002 data to SQL
- Self-certify in XP
- file prompt - more info
- ScoreCard
- SMALL(?)
- How do I? Link Row Headings
- Excel 2000 macro error
- Dynamic Status Bar Routine
- Dynamic Table of Contents
- Code is dragging selection when should copy
- excel reader
- Export textbox value into a spreadsheet cell
- identifying shortcut keys associated with custom macros
- Locking/unlocking cells
- Which workbook is stuck in memory
- Which workbook is stuck in memory
- Dump 5D VBA array to 2D excel array
- Problem with using a macro to create a chart
- file prompt
- Excel VBA - automatically extratcing data from two different files
- multi-file open to one workbook
- Autofill - Autonumbering
- Where can i find the vba documentation
- Limiting the cells a command button can change
- VBA - Only Selected area visible
- Determining biggest variable
- Tricky Question Re: File Properties
- Ascii
- insert row...with reference
- Excel VBA-Looping though MultiSelect on ListBox
- Sort Method Questions
- Insert
- ambiguous name detected
- Excel with Access
- MANAGING PRICELISTS
- Iteration programing
- Executing Windows Comands using VBA
- Adding up Time like decimal values ??
- Object Calendar 8.0
- Comparing 2 worksheets
- Disappearing Posts
- Hiding rows based on cell content
- Changing the contents of a cell... dynamically?
- ParsingName
- Hiding #N/A
- start up screen
- Excel VBA - Automatic adjusting of 2 windows
- Download (copy) file from the internet
- Crazy Combobox
- formula to follow preceeding value
- Macro dislocated
- Getting system information
- copying text from one group of cells and putting them in a table?
- Stripping data
- file browser when a cell in selected
- importing large numbers to vb results in the numbers being formatted to scientific
- Checking contents
- General question
- Remove value after decimal point
- Introduction to VB and Excel
- Finding out the workgroup templates path
- next available row
- How to find used range of a row/column?
- Deleting an Excel cell
- Excel VBA-Looping through Multiselection
- Missing Files
- VLOOKUP into another workbook
- Double-click entry
- Highlights
- Dumping multi demensioned array into excel
- What does "Application-defined or object-defined error" mean?
- running one macro from within another
- Max of VBA Array
- Automatic Macro in Excel
- Hidden Column in VBA
- Clip Board
- Calculating Average on variable sized datasets w/VBA
- 2003 tax copies
- Export information to Access.
- Run-time error '1004' PasteSpecial Method of Range Class Failed
- Macro to make a cell work like a check
- Solver and Excel programming problem
- Changing project desktop icon
- VBA code for: Saving to desktop?
- Excel VBA - Sort a table with BubbleSort
- Autonumbering
- Copy Table to New Sheet
- finding a common set of numbers in separate rows
- Setting a print range using variables
- If then Cell comparison with text.
- Reassigning macro to add in function
- SQLOpen VBA
- bug submission?
- multiple user DB access via Excel (troubleshooting?)
- Merging Files
- Problem, need urgent help!
- Sort using 4 keys
- Lookup 'Like' values???
- "Application-defined or object-defined error" while printing excel report
- Web Query
- Comparison
- Excel Relative Macros
- "runtime error 9"
- Multiple Macro help
- Simple programming question
- Macros to Create Pie Chart
- Macros work on my computer but not another???
- Macro moving a directory with XP
- How do I?
- Changing cell value depending on dropdown list
- Assign button to run macro
- Add drop shadow to cells
- The cell address of a button?
- Need vb to automatically download from https website
- Printing a legal sized document on letter sized paper
- Copying from excel sheet on IE webpage
- Selecting a printer
- Grouping Event handlers
- Convert "merged" cells to "CenterAcrossSelection"
- Macro to move, create formulas and loop
- Simple VB Script - Part 2
- need to append range name size with new entry automatically
- print row
- Resetting cells
- documented memory leaks in Excel 2003 or OWC11?
- Forcing legal to print letter
- XL97:Combo/DropDown box and Not In List
- Inputting data from Userform
- New to macros
- Any simple method to convert Lotus 123 program to Excel VB ??
- Combobox selection
- Comments
- Data Comparison
- Simple VB Script needed
- add end rows after suppressing prior rows
- If Cell in row has data then do this: HELP
- How to import Text file to Excel
- pull down menu
- Saving only 1 sheet of a workbook
- Calling Add-In subroutines from other modules
- Do not print if error
- how do I build a pause (or delay) into my macro?
- Trigger Code with Mouse Click
- Macro: Excel 2000 does not work, XP does...
- Icons on toolbar buttons (Was: Toolbars with macros)
- Inserting comments
- SQL Select statement with Date as
- Inserting comments
- cammandbutton into a graphic sheet?
- Column aliasing fails in ODBC queries w/multiple tables
- Problem with Application.Width
- Visual Basic Code
- Extracting info from different rows (& columns)
- Overriding Actions of Excel DropDown Menus and Poup Menus
- Excel Database in shared environment
- Vlookup - Multipel results
- Checking contents
- Mail ID from wabsite with VBA
- Need help with array formula to count rows w/ mult.criteria
- checking drop down
- MSDN Library
- Emulate Access with Excel - display form for data entry
- Macro problem
- Toolbar with Macros
- Navigating in big list
- Suppressing links message
- Set Range Var with address length over 256
- Watch cell value
- Mouse in Code View
- Eliminating Blank Rows + "COUNTIF"
- Data Tracking - Update only with "save"
- ListView to Excel Code (but needs SPEED improvements)
- VB.net and Excel COM exe
- Validate Cells based on if conditions
- Why "User-defined type not defined"
- Some VBA questions about cell selection
- Conditional Formating issue
- lookup and offset combination
- Copy-Paste while looping
- FileDialog
- ComboBox DropDown when Key is pressed
- Efficient Looping
- Copy Column and Paste
- Positioning the Insertion Point in a TextBox
- Sending email from Excel
- download a file from a webpage with VBA
- Data Validation Questions
- Custom menus clean-up
- link text box to Enter Key and button
- Showing Pictures
- Detecting a network connection
- Changing www links in spreadsheets
- Finding substrings within a string
- Clipboard
- Just a button
- comparing columns from different sheets
- Re: Clear Clipboard
- Re: Using BeforeClose for deleting a custom toolbar
- order worksheets alphabetically???
- Enable/Disable Button
- Responding to Outlook Errors when useing Sendmail!!
- Re: Picture Tiling property
- Using functions in personal.xls
- how to know the number of lines on the sheet?
- Trying to select the visible range of cells
- Re: How do I update calendar control 8.0 to 10.0
- Re: Delete characters up to ":"
- Re: Help
- join more workbooks in one and print sheets
- Re: Write a macro ro copy column at certain time of day.
- Re: Help
- Re: Workbook_Beforeclose vs BeforeClose Event
- Re: Screen flashing during macro execution: Interesting observation
- Re: Mapping macro
- Re: Help
- Strange vlookup problem?????
- Self-updating shortcut menu
- form macro
- Formulae required
- stars **** in cells
- Setting the default file name in the XLDialogSaveAs dialog box
- Run VBA from Hyperlink
- my stock quotes
- Convert MS Word table to Excel
- Can anyone help?
- Help with data entry form please
- 2 lists of values - identify differences?
- Find row number of maximum value
- FUNNY BUTTON
- Cell Background Color
- use a txt.value on a form to search a sheet
- Calling lookup table gurus.
- 2 or 3 rows, not just one
- Save As - using data from two cells
- Converting Access dll calls to Excel program
- Find cell select row and delete
- CreateTextFile not updating file
- Sendkeys and NumLock Key
- VBA code halts after opening a file
- VBA on the net?
- For Robin Hammond
- Can not set Y Values in XY chart
- What Tasks Can Be Automated?
- create worksheet and insert row
- COM Interface and IDE caching
- Scroll Bar
- Publish to Web, Zero Values setting not saved
- Creating UserForms in Excel
- Jump to section in Validation List
- If values in two columns are equal I want to automatically execute a macro
- Excel auto macro problems
- Re referencing an object
- Trying to make cells numeric only
- Array MATCH function for VBA
- Need help subtracting time values
- Understanding Selection "Type"
- Multiple Recipients in SendMail Method. HELP!!!
- Array Lookup
- Text box format VBA
- Date Function
- A counting problem?
- Passing Excel formats in VBA date variables
- Running Multiple Modules With 1 Command
- Macro help - copy row, clear, and paste on different sheet
- Dynamic 2D Array
- Print single sheets from rows of data
- Terminal Server 2003 + Excel 2000
- Canadian Postal Code
- Reference Access created form in excel
- Form.Refresh doesn't work...help !!
- keypress to fire command button
- CurrentRegion Selecting
- Excel Product Id
- colorize row if...
- Run-time error '424': Object required
- String to Range?
- Vlookup Multiple
- determining coordinates for screen placement of user form
- Moving the Command Button
- Code for Subtotalling?
- Macro - copy entire row and paste at bottom of another sheet
- excel VBA problem
- unwanted zeros
- copy and paste in different columns with conditions
- close(savechanges,filename,routeworkbook)
- formatting for feet and inches
- Shell
- CopyFromRecordset not starting at current row
- Number format in vba
- How to "push" a value into a cell
- Wrapping Text with VBA
- Link to User form
- class? Compile? XLA?
- String to Array Conversion
- path strings
- Please Help (text file to excel)
- Similarly helpful AccessVB forum?
- Security - Protecting Macro while generating workbook thru VB 6.0
- Running Code Automatically
- Overlapping combinations problem
- Print
- Graphics
- Reference an image in another sheet
- Range Question
- add another text box
- a label for each name in a list
- Change Event.....Cell character count
- Change Event.....Spell Check
- what does (ByVal Target As Range) mean
- check writing text
- import- export XML in excel without loosing XML format
- Disable Print Button In a Single Workbook
- Using Spinbutton to change a date
- bank account
- what's the Bug....tell me what's happening???
- #value
- Sum accross sheets
- Autosave of xls files in csv format with macro
- Publishing VBA Functions
- cells in ascending order
- Excel Automation Find/Replace Excel 2000 and 2003
- On error resume next statement ignored!
- Scenario
- Loosing Cell Selection
- Hide/Unhide sheets
- VBA and norminv
- Input mask for date
- sub directories
- True and True
- Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each...
- Automatically converting to HTML
- OnChar function
- Macro to Modify Another Macro
- Automatic execution of macro
- Automatically adding ':' to Military Time
- sheet.columns("K:M").EntireColumn.Hidden = True
- search for cell value and return row values
- Office Assistant Balloon User Input
- SetFocus in user form
- Populating a 2-D array
- Groupings
- Graph Simple/Quadratic equations
- edit a macro using a macro.
- Corrupt File
- Searching a txt file for splitting into different worksheets
- zip codes as numbers
- easy combo box issue
- MOST & LEAST OCCURRING INTEGERS !
- Protecting worksheets with Macros in Shared Workbooks
- option strategies
- How do i express this in number
- opening a form automatically
- Speed--Excel 2003 RAND vs. VBA Rnd...
- If statement or another formula help
- Runtime error '429': ActiveX component can't create object. HELP!!
- Speech.Speak error
- Global Variables using User Forms
- Urgent
- UPPER and Proper Case
- Export to CSV to speed up Loop
- Keeping name of worksheet who called macro
- Re: Change active cell properties with command button
- menubar buttons don't appear
- listing macros associated with shortcut keys
- Excel password but cant hide the sheets before entering password
- two things: auto email and archiving
- Insert a value based on unique valuse in a row
- Copying Text from TextBox into cells in table and then addign a new row
- Setting the Values Property of the Series Class
- Keeping button pointing to original workbook
- Macro not showing in Excel spreadsheet
- Adding Hyphens in a number
- capture paste event into a cell
- MouseMove causes Excel Crash
- Pivot table
- How do i find the last cell range in a sheet
- Change active cell properties with command button
- Turn Off Warning in Macro
- GROUP
- Help with Pivots (.Pivot Items) - Excel 97
- Can I make my own FaceID's?
- Calling Sub with Parameter from Menuitem
- Hide toolbars
- Maintaining column formatting when copying a row to another sheet based on a value
- Trap CTRL+C keypress event
- Forms Box
- auto sort
- Passing ClientCertificate data from excel to asp/aspx
- WorkbookOpen
- Check if activesheet is protected
- excel vba date format prob.
- Visual Basic editor terminates Excel 2003
- Linking EXCEL WORKBOOKS
- POP-UP
- chart updating
- How to fill a sheet in Excel2003 with CSV data?
- Convert data from MS Word
- Existance Check Fails
- Cell lookup
- Line insertion
- Please Help (text file to excel)
- Runtime 1004 unable to get find property of range class
- Hide all menubars
- Get Max Date From PivotTable
- Dialog boxes in Excel
- Kill Command
- filter problem
- Force Macro Enable
- Format dates in VB
- How to load a help file using VBA
- Code to make sheets in a workbook visible
- Excel App "invisible" to user
- Most Interesting Problem I Had Ever Got.
- Why does sendkeys seem to loop
- Help - setting up manual recalculation when opeing a file (but before it starts recalculating)
- linking excel sheet to access using code
- Autohide Rows based on condition
- How do I get the file properties?
- Excel 2000 code not working in XP
- Don't Update Links to Ext Workbooks using VBA
- Access protected VB code by initiating password dialog box
- Error Handling
- Double-click date entry
- OutlineLevel and Integer Variable issue
- Making GIFs from anything, with optional resizing
- Append data
- Excel 5.0 entering date
- Generating reports
- Oh no! Need help on unprotect password protection
- VB Error: Paste Special method of range class failed
- How to auto hide an empty row with VBA?
- How to retrieve content of the Excel cell?
- VBA - Today() not available in VBA?
- searching sheets in large workbook?
- SaveAsUI
- Import form from Access?
- Cannot install Excel 2002 Analysis Addin Toolpak
- VBA - Looking to strip alphanumeric from numeric
- Knowledge Base 247412 need help to make work
- how do I: launch a macro if two cells do not equak one another?
- Re: Command Button that changes cell properties
- Duplicate Email Addresses
- OnTime Help
- Date Entry Script
- Assigning a Range to
- File Searching
- RANGE & NESTED LOOPS
- lots of text in text box problem
- Log Normal Distribution
- Show changes after a Merge Workbook
- Timer control
- Stats Question
- Deleting Specific Rows - urgent
- need a function (not macro with ontime) to record a snapshot of a changing cell
- Filter on a Protected Worksheet
- also,
- Not Unloading a UserForm
- Identify Blank Cells in Col & move coresponding data
- Kung Foo Masters Only
- calculating age from date of birth
- VB coding for formatting time used in calculations
- Edit Array Funciton
- What's the best????
- Customizing pivot table with macro
- Globally define all Excel worksheets as text
- Excel VBA Save As
- SolverOK problem - very frustrated, please help
- CombBox - Object of What Collection?
- Forms blank out, periodically
- Auto filtering with form type pull down menus
- Problem with Alan Beban's ResizeArray
- Display unique values in a range.
- Merging copies of worksheets
- enter data from a form to "found" fields
- Defining Trial Period of VBA Code
- Matching problem....
- Pivot table question
- Select through last non blank row in a column
- Path in Footer
- Post Excel Data to a Web Server
- How do I get macros and hyperlinks to update when I change the name of a worlbook?
- pasting cell range in an email
- Comment Indicators - can I change the color of the little indicator ...
- Maximum Absolute with sign
- Toggle Hide/Show
- Userform web Data query table
- Conditional Formatting
- Merge multiple cells
- Second subroutine to run automatically
- 2 Collection questions
- Custom menu depth
- Modifying pivot table changes chart type
- Excel not prompting to save Add-ins
- Excel programming book recommendation
- Unhiding workbook when loaded
- Append Data to Table after Web Query
- Combine All Worksheets into one
- vba help doesn't work
- Concatanate odd rows
- CheckBox Event
- Testing for null or empty
- very Important
- OLE DB Provider
- Help with SaveAs
- Compile Error on "dim x as VBComponent"?
- Old Macros in Excel 2002
- Knowledge gained from Access to Excel VBA Automation User request
- #N/A Errors to 0
- Multiple Instances of Excel in WinXP Pro Task Manager
- Re: Toggle Hide/Show
- Linking a Word Field into Excel
- Acrobat 6.0 and UDFs
- Automatic TickLabel and TickMark Spacing
- Excel Version
- macros
- Including .csv to end of filename
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.