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 |
- Populate a combo box from a worksheet with VBA
- Select item in drop-down list in Vbasic
- Why doesn't "private" work?
- Using excelObj.ActiveWorkbook.SaveAs("C:\MyWorkbook.xml" , FileFor
- preventing macros from clearing the undo list
- Simple Sound Macro
- Complex Query Not Able To Get Results in Excel
- Full xpath support in visual basic?
- Collection as parameter
- Macro (can do a save as.
- VLOOKUP formula
- copying worksheet
- IF = text Show "NIL" ..?
- UserForms, mandatory completion of fields
- Print Preview
- SaveAs Code
- VBA
- Digital signature
- Date and Time Formats in UserForms
- Create Function like Sum()
- ??? Combobox auto go to selection
- lines in user forms
- Can i use lines in a user form in excell
- how to add column with the workbook-filename
- check exist of filenames in column, mark red if missing
- Macro Help for Deleting Blank Rows & Clearing Cell Contents
- macro creation to format mulitple rows in a list *difficult*
- Macro slow after 2003 upgrade
- Error using VSTO and ImportXml when cell is being edited
- Saving worksheet Data only
- FILTER ROWS THAT MEET THE CRITERIA IN THE LAST CELL OF THAT ROW?
- hierarchys - can you build an elegant hierarchy using vba
- Paste Value Multiple Sheets
- currency macro?
- Go to what I just typed
- Find Macro
- try [code] next
- VBA
- Colon in code?
- Multi Colum Listbox in UserForm
- Application.Run problem.
- Copy a range to cells above range
- Shared workbook opening and saving very slow
- Help with lookup or if functions
- Return WB to original state
- continued issue with countif function
- Macros within formulas
- a strage kind of graphic
- custom toolbar for each sheet in workbook?
- Help with Macro for work
- Macro to name ranges for selected worksheets
- Help - Excel Automation: Turning off all dialog boxes (prompts).
- Remove blank rows without hiding them
- Recent File List Problem
- Useform Cascading Like the Solitaire Cards when I try to move it
- If cell = number ?
- Manual Calculation not working?
- using countif from a vba macro
- Copying static cells in a loop....Paste Special problems
- Macro signature disappears.
- Paste Special issues
- Automate Page Break
- Drop Down Boxes
- Export Date Format
- .Find Method for Excel 2002
- Not Enought System Resources
- Hiding and Unhiding Sheets
- XML Refresh Code
- xl4 command
- Adding read receipt to CDO code?
- Code to search and replace info on modules
- Option Button - Cell Link Issue
- Outlook Event Entry
- Hiding and Unhiding Worksheets
- Why is this a number?
- OnTime
- Excel macro to insert blank rows at a ever-changing interval
- Sorting Multiple Sheets
- Open Word Document from Excel Userform
- Diable Ctrl+Break
- countif AND countif something else too!
- countif AND countif something else too!
- Go to 2nd row below last row
- Pointing directly to a cell in a range
- a strange graphic
- getting error out of memory
- Update Links
- Using a database to create new worksheets based from a template
- matching 24 different values to a specific value
- Is it possible?
- remove vba and functions when saving worksheet
- Data Filter Function in VBA
- Getting a cell reference
- Close File
- xls file requires Domain Admin to save locally
- Auto reszie a row with wrapped text.
- macro open files
- Drop Down Boxes or Macros?
- Passing variables between workbooks
- Paste blank cell row loop
- Text box pop-up
- Students and Courses
- SOS: Excel custom Toolbar
- Programmatically make cell pointer invisible
- Put variable into text ?
- If Value Problem
- Button not showing graphic.
- Run-time error 1004
- Brain lock: using array formula within VBA?
- Sequentially run macros
- Macros
- help with this function
- checking a sheet for identical items
- Variable in formula
- Macro for multiple charting of multiple datasets
- Open a semi variable name with a macro
- copy paste values only using destination:=
- question about Web Query
- Making sheets with a macro
- A strange kind of graphic
- Another cell formatting dependent on cell contents question / message box popup?
- Excel macro, editing recorded cell.. not current
- formating cells
- exclude international and national holidays into conbobox...
- the macro don't execute
- Protect cell pls help...
- Changing Background Colour Based on Cell Contents
- Copying the data from the other worksheet
- Putting a search box
- Template path
- Create new workbook, temporarily name it and copy sheets to it
- Extract Target path from a shortcut
- Repeating some code on all worksheets
- How do I trap errors when excel (not a workbook) launches
- help with graph
- Macro again..
- 1004 and Cells
- Paste All Problem
- Pivot Pagefield multi-select? (Excel 2003)
- Timestamp - automated based on the next cell
- type check
- macro with external script.
- syncronising workbooks
- File copy
- Cells Range Error - URGENT
- getting data from excel worksheet in to a script
- Workbooks.Open fails
- Macro to replace another macro
- saving backup
- copy and paste formulas that apply to multiple worksheets
- Open Access Database from Excel
- run a macro in excel formula
- Multiple selection
- Subscript out range error when redimensioning dynamic array
- Excel Add-in for SQL Server AS - Documentation re Calculated items
- How do you Export Excel data permanently to Access
- Copying entire row
- Loop routine fails after 10 cycles......
- Help!!! I have problem deleting 2500 rows of filtered rows
- run-time error?
- run time error
- Conditional Printing of worksheet
- Dynamically Activate a Combo Box
- copy and over write *.jpg files
- Any news from Bunny / TRA on how we did in court on 1/10/05
- Comparing two coloumns text contents & extract different values
- Searching for patterns in text split into adjacent cells
- Capture Find Settings
- Is there a way to install Excel if I use XP?
- color for last day of each month
- WorkbookBeforeSave
- Number formats after breaking links
- two small questions
- Closing a Workbook
- DateTimePicker
- excel input date format
- How can I do AND operation on two binary numbers in MS Excel?
- problem determining a cell's value
- Need help re VBA for Worksheet Open Event
- disable message box during VBA code execution
- Convert cells to HTML
- Merging Columns, keeping text
- Merging Columns
- 1004 "Application-defined or object-defined error"
- MSForms.ReturnInteger assignment
- How to export/save the track change history into another worksheet?
- Help with "Selection.End(xlUp).Row"
- FORMAT CELLS
- Pulling up the Find and Replace Dialog via Code
- Maintaining Column Widths When Copying
- Excel 2003 addins don't automatically open
- Chart VBA Question
- Updating links
- Creating an Excel sheet with Addresses using a Macro
- Code created in a Macro not working for a Command Button
- Macro not working
- Splitting text document into chunks of 100 characters
- Concise border removal method
- how to remove blank rows from a sheet using visual basic sode
- Determine whether a wrkbook have been changed since the last save
- Macro Writing
- Excel keeps converting my %s to Time format
- Sum all cells with interior color...
- Help on VB Excel
- Exporting CSV Files
- Linking question
- Number format locale - XL2003
- Unloading / closing a form with the escape key
- Replace CR character in text pasted from Access database
- Format Excel Column via code
- How do I attach just one Excel worksheet in an email
- Change Shape Name
- Textbox Date formatting problem
- EntireRow.Delete, Causes Problems In ComboBox In Another Workbook
- Conditional Worksheet Access Problem
- Change Event Problem
- animated graphics in excel visual basic
- Using the Solver in a VBA function (not a macro)
- Help with creating a formula...
- Solver does not solve when called from a macro
- Mail_ActiveSheet and DeleteAllCodeInModule
- automatic exporting of data
- Database Search Form Help?
- And/Countif formula
- Need help with Macro in moving columns
- Format subtotal rows
- Macro Open Files
- multiple comboboxes to change displayed images
- Creating a Purchase Order Form
- Merging data revised
- Function Not Recognising Values in Populated Ranges
- Subtotals
- Wrong Number of Arguments or Invalid Property Assignment???
- Select number of rows in a graph?
- Wildcard to pull all data
- Row from database in Excel sheet
- How to add a new sheet with a name
- Scrollbar flash
- colouring a cell
- vba code to record a macro
- Can I do this with arrays?
- Pulling files in using Macros
- Defining sheets to be created
- Inserting foreign/special characters from a database
- Multiple "IF" statements every cell in range
- Can Visual Basic 2005 be used in Excel 2003?
- PivotField AfterUpdate event?
- Worksheets.OleObjects
- a letter equal to a number
- Count if with several areas/conditions
- Subscript out of range (Error 9)
- How to evoke a hidden userform?
- Group controls
- Form not unloading before next code line
- Range names in a Excell macros
- RESIZE USEDRANGE
- re-calc
- appending some text/html to the "discription" field
- dimensioning variables
- excel to word
- Button on a sheet always visible
- splitting information into 2 cells
- Sorting code
- checking Column for matching value
- Need Help with Dynamic Chart Worksheet Change Macro
- Macro problem...Will be a real challange
- Can't see all of one of my sheets
- How to distribute Macros/write add-ins in Office product
- Validation List advise....
- Duplicated occurrences of class variables - VBA in Excel
- Duplicated occurrences of class variables - VBA in Excel
- Auto notify a list of people via email when excel file is closed
- how to match/compare cell values
- Data validation, alpha or numeric characters
- bug in Excel 12?
- Create Hotmail Msg from Excel
- looping through chartobjects returns deleted charts also
- Excel PageSetup Error even when a printer Exists
- empty cells
- Email Help Please
- EssVSetGlobalOption , 6
- Command Button Date/Time Stamp
- Merging Macro - GetOpenFilename & Workbooks.OpenText
- Import Text File Into A Spreadsheet with over 65,000 lines
- Retain Format When Coping Visible Cells Only to New Worksheet
- How do I turn on relative reference(?) in a macro (97ver had butto
- Using DSUM on a Recordset
- BackStyle Property misbehavior
- VBA - remove all empty rows in a worksheet
- Can an Excel macro be automatically run based upon data in a cell?
- copy row and paste to another worksheet
- same info different sheets different cells
- Emailing an Excel sheet?
- optimization question
- File Could not be Found
- Automatically enter custom worksheets?
- Last Saved By property
- VB 255 character limit for strings
- Copy Sorted Coloumn
- Displaying Multiple values with message boxes
- Displaying multiple values in a message box
- if statement
- Rounding Numbers
- OnKey
- Clear selection?
- inputing data
- VBE Module Names
- MS Query - '' is not a valid name
- How to populate an MSForms.ReturnInteger value
- Multipage questions
- Problem copying sheets
- Text Export/Append
- active cell
- VBA Deleting in database from list box
- Test User before saving a file.
- Eliminating Multiple IF/THEN loops
- V Lookup w/ unreliable data
- Forms - Named Range as the RowSource
- Required fields
- Merging data
- Macro syntax to open file in current explorer folder
- RE: Divide Monthly Sales Budget to Day budget
- Macro Location Problem
- Call Excel Macro in VB.NET
- Issue in VBA functions
- Refrence to Listbox in form
- Copy Sheet
- Excel 2003 - Keep a Macro Running While the Workbook is Open
- How to pop up a Macro when the cell in one column is selected-urge
- Mail_ActiveSheet()
- Notification
- get data from an Internet Explorer Table
- Return Array from Function
- shifting data in excel (logs)
- Double lookup count
- runtime error 424
- Searching for and Pasting Data to a new file
- is there a way to do this
- ORACLE SEQUENCES IN EXCEL
- VBA Code
- Error Handling on my program
- PHP's fgetcsv converting ¿0a to \n ?
- Inputing data twice into a Query
- Only Printing Header on First Page
- Looking for the truth !!
- Userforms and Checkboxes
- Turning Off Circular Refrences on open
- Opening an excel workbook doesnt work
- Adding an Add-in to a menu
- Writing a macro
- event triggered by cell format change?
- Adding an OFFSET condition to a COUNTIF??
- How to disable Max button on the Excel Workbook
- Selecting all sheets and sheet methods
- Macro finishes faster when left clicking during execution
- export excel data to another sheet
- crate formula in VBA
- Unlock a vb code of a workbook
- Excel to open word document -basics
- Why do VBA and Excel floating point results differ?
- multiple range using GetRange()
- Deleting in a list box
- vba
- adding code to a workbook programmably
- inputing data using vba
- IF Clause
- Copy rows from different worksheets
- Returning the index of an array value?
- Save as file name and specific field
- Populate word doc with excel data
- 'Cell is protected' after VBA runs
- Decompile Excel VBA code
- Hyperlink multiple Images in at one time
- Control Tip Text on Excel Command Buttons
- Excel-Web Queries to Babelfish
- corrupted .xls / Copy Modules???
- Code to Advance filter a list in a shared workbook
- Coding questions about UserForm TextBox
- add comment to object
- Excel template in Public Folder opens actual file
- Late Binding Issues - My Bad
- Help with UserForm textbox code
- writting data in the next available column
- Late Binding Issues
- Creating spreadsheet of Outlook emails
- Need to compare values in two colums and delete accordingly
- Dynamically change cell range in formula by background color?
- Show value of variable on mouse-over in debug mode - bug?
- Copy method of worksheet class failed - help!
- lock button position
- AutoFill Weekdays problem
- Setting The Print Area
- Define User Access Levels to Workbooks
- How do I learn to write Visual Basic into an Excel Macro?
- File Error - data may be lost???
- Toolbar should not be on its own row!
- Compile Error
- Help with UserForm textbox code
- ComboBox Range
- Re: Variable range of rows
- How to Combine Data Regions
- Linking a cell to a textbox
- Insert Hyperlink
- SAP Late Binding Problem
- Insert leading spaces
- Corrupt Excel File
- Code to hide Entire row based on criteria
- Sum Question
- Zoombox
- Remove ' if not followed by two digits
- How to Connect Data with ComboBoxes and Dependency on each other
- Posting times to an Excel spreadsheet
- Custom Number Format
- How to wrap text in a ListBox
- Print Macro
- ADO Recordset.Filter in Excel 2002
- Performing Action On Multiple Values In A Column
- Marking Dupes
- combining two worksheets into one
- Enter Formula via VBA
- migration issue - OpenText method crashes Excel.
- Is there a list of VB addressable fields for Excel ?
- HOW TO: Name Range?
- Run-Time error 1004
- Return selected option from a control
- Runtime Error
- calculations based upon months
- Userform Status
- Identify the column of a range by letter instead of number
- Syntax for Logical Operators to Limit Input?
- Missing library in Object Browser
- Modifying an Old Excel Macro
- Check for duplicate values?
- Macro To Scroll Worksheet Automatically ?
- How to exclude certain cells from a range?
- Selecting a range from second row onward
- Changing save as file format for excel from VB.net
- Excel VBA: Automatic grouping same entries
- Concatenating text
- USERFORM DISAPPEARS ON EXCEL MINIMIZE
- If number then... how?
- Protect cell and remove row datas
- FollowHyperlink failing
- Macro for counting the number of filtered rows
- ITeS and BPO jobs or Projects
- ITeS and BPO jobs or Projects
- New to accessing mysql dbase in excel vba
- Save As
- Refedit gets mad with touchpad
- replace one tag in content of one cell and format not changed
- Excel Got FOcus event
- Keeping a named range between 2 dates??
- Fill empty cells
- Multiple column Combobox
- Connecting to Simcorp Dimension
- Moving worksheet
- Shell command to post to notepad
- The form name changes everytime we open the page
- interesting solver problem.
- Help in Pasting from 1 workbook to another in code
- Code help required
- Copying a range to a new tab
- VBA Excel Chart DateFormat Language Settings Locale
- Need Help using/calling a Reference
- Alphabetize when data changes
- Compare data between 2 worksheets
- Need Help using/calling a Reference
- Scriptin.FileSystem Network Unavailable
- Scripting.FileSystem Network Unavailable
- macro to input data on a specific date
- Need help with this formula in a macro, please
- Re: Calling a DLL Trouble
- vba range in vlookup
- how to loop thru cell in 2 columns
- How do I automatically calculate dollars earned with time worked?
- how many Fridays in a specific month in Excel
- Macro for importing data from one file to another
- How to pick the first day in and the last day out in a PivotTabel?
- VBA code for different versions of Excel
- export as vba macro
- How to print specific worksheets
- Identifying duplicate content in column
- Excel problem using DisplayAlerts
- How can I alter this Macro?
- Executing a subroutine from within a loop
- Calling a subroutine in a loop
- empty cell
- Pivot table question
- Pivot table question
- How can I alter this Macro?
- Resource Planning - How to Model?
- Search multiple sheets, then paste results in new sheet
- What does the '#' character mean when appended to a number?
- Alter mask of image on button
- Writing to a range of cells
- Looping
- cloneing cells in different worksheets
- Simulate Access' After Update Event
- Protecting worksheet within an Macro
- Using macros on different versions of Excel
- Need Help using/calling a DLL
- validation
- Help with ammending a script
- Need Help Using/Calling DLL Please
- Disable events
- EXCEL: put_DisplayAlerts fails if user is entering data and clicks toolbar button
- Customize ROW/COLUMN header
- Error 400
- Arrays and Join Function
- Dependency problem
- Web Query Error 1004 - Cannot insert columns...
- imitating cut and paste
- Creating Multiple Scorecards/Files and Compiling data
- Calling a DLL Trouble
- Marco and command buttons
- Is Excel VBA best for me?
- Mapquest Web Query issue
- Cell value change to trigger macro (worksheet change event?)
- Rounding
- Web Query: Obtaining source link from a cell in a macro
- Put a Formula into a Cell with Index
- compare two col data & add info
- Accessing specific items in a range
- Formula in a range which varies in size
- Integrate Word and Excel
- Prevent Duplicate Validation List Entries
- Copy the 14 cells and transfer them to another sheet loop
- Keeping the exponent at a fix value in Excel
- Re: How to share files
- Pivot Table help!
- PullDown List with two Columns help!
- VBA Help: delete whole row if the cell does not contain string "*"
- New custom FaceID for automated button
- Worksheets
- characters and values
- Conditional Formatting
- Built-in Excel constant for maximum number of rows, for columns?
- ERACE MESSAGE FROM GROUP
- Can't open VBA-Code Window
- How to program an auto incrementable number in a cell, at each ope
- vb help, convert excel formula to vb formula
- Please Help!! DD:HH:SS to seconds driving me mad
- Removing and Restoring Excel toolbars
- Is it possible to create a patch or update an Excel Program?
- VBA Code
- Inserting a formual with " in it
- Remove screen 'flicker' on executing code
- Variable Picture in a Form
- Search Range for item in seperate range
- Page setup
- Excel
- Master reset code bug - stumped again
- Elapsed Time
- Is it possible to embed a dialog in a Form?
- macro to insert rows & copy cells
- Object variable issue
- I don't know if this is possible to do but....
- Maximum number of worksheets in Excel 2003
- string
- Share:Fix a time not to be exceeded
- printing ppt (to pdf) from excel
- "Enter Key"
- create formula to compare cell 1 with a range of cell
- Absolute Worksheet References
- size FaceID picture on commandbutton
- Excel 2003 Power Programming With VBA
- Master reset code -stumped
- Finding Asymptotes from a set of data in Excel
- "Excel 2003 Power Programming With VBA" John Walkenbach - pls share
- to previous location
- how can i call macro in powerpoint file from excel file
- Using a Macro to Change the Value of a Check Box or Combo Box
- Using "Equiv" excel fonction in vba
- Application.OnKey syntax for + and - keys
- Selection of data in a sheet
- Color Palette
- save and closing when hyperlink accessed
- Scroll through Range
- Excel Form ????
- Prevent UDF from calculating when opening file
- How can I get Excel filtered data into a word mail merge using a m
- I'm not even sure this is possible anymore!
- Error 1004, Application-definded or object-defined error
- Excel error when called from vb script
- Excel error when called from vb script
- Macro to access data in an array?
- User Interface for Viewing a Collection of Data Files
- How to trigger a macro at regular intervals?
- Transform table
- Finding cell closest to textbox
- Disabling or capturing a Delete Sheet command
- csv files not opening in full excel.
- updating all links in powerpoint presentation
- Sharing a workbook breaks VBA code?
- Add new entry to list
- Mail a row to each person in a range (HTML) - by Ron de Bruin
- Modify a process priority
- Change Order of Inserted Worksheets
- Finding the first empty cell in a column
- Testing Range to see if value in another Range
- File as TSR
- Combining cell values in a list
- Adding the VB Timer Control...
- Copying Data from various spreadsheets
- Creating a year of weekdays automatically?
- Offset
- Break link between excel and access
- Changing Sheet Names
- Prompting a user to open Read Only
- Copy From One WorkbookTo Another
- VB Code For Macro
- Multiple versions of excel ...
- Editing an Excel MAcro
- Excel VB Programing
- freezepanes
- How to compare values in different columns and indicate outcome
- Combinations from group in Excel
- merging multiple named ranges for validation list
- QUERY: API/SDK for Excel
- Quickie... How to change a name with a macro?
- Protected Excelsheet
- Drop Down List
- Trying to autopopulate a Save as filename
- A macros for listing information
- Rightclicking with 'sendkeys'
- file error: data may have been lost problem
- Save a cell location and return to it
- Problem with Dialogs(xlDialogWorkbookNew)
- Checking for the border style of a range
- Searching through the contents of a Folder of text files
- Excel Functions - Recursive
- Runtime Error
- a
- Help with Macro. -- User input for sheet name
- selection.copy - how to emulate Paste command?
- Hide Rows meeting condition Amendment
- Saving backup file on file open
- cell formatting
- Importing data from text file
- diff toolbar for diff workbook
- add numbers to a list on a conditional basis
- Work out Days Between Two Dates
- Pivot Tables
- How can I use a macro to hyperlink multiple files at once?
- How to copy and paste in VB
- Help needed with setting up a complex directive
- How to color pages of Multtipage
- excel help --- urgently
- copy data from a specific range to another sheet
- Excel Average Function help
- Subtract 1 year from todays date
- "Show Placeholder" feature in options/view doesnt work
- "Show Placeholder" feature in options/view doesnt work
- How to create a formula with ListBox toa othes Sheet
- Compare and Lookup
- Multiple Columns to Freeze
- HTML
- combine data from multiple worksheet
- Positioning Numeric Values Resulting from 6 Column Array Formula
- Macro to edit Range Name
- Creating a .EXE to run excel macros
- Macro to import from one closed workbook
- worksheet change
- How do I find out if a cell has my word in it?
- converting ppt to pdf launched from xls
- Excel Analysis ToolPak - Bug when installed from Code
- converting ppt to pdf launched from xls
- I don't want to see scroling which VBA does, adding a progress bar
- On Time Function
- using Formulas in VBA
- Could someone please debug this short macro for me? I'm stuck!
- Macro To Move Cell Over
- Automatically Update Cells bases on another workbook.
- Cut & insert columns not working
- What's wrong with this code? Please help.
- Temporary Folder Location
- Excel User Form using 2 Combo Box with 1st Combon controling the 2
- changing font type in a footer
- Is it possible for a single chart to have multiple Y axes scales
- How can I move a sheet to the end of the workbook in VB?
- vblf and vbcr one last question
- Programatically Unlocking a Project in the VBIDE
- Pulling apart a string
- Worksheet_Change
- Sum in a dynamic range
- Print List Box
- Can't see opened workbook
- Picture Cropping Challenge
- Releasing reference to the Application object before exiting
- Run macro from name stored in variable?
- Assigning multiple text strings to variables
- Can macro display a diff't screen while it runs until it stops?
- how to call a function procedure
- left padding + blank
- Having trouble with "vbcr"
- change type of a file
- Datepart problem
- NEXT/PREVIOUS OPTIONBUTTON
- Please help with Application.Wait ( )
- Excel User form - print landscape
- Trouble Passing An Array
- Format data
- If statement formula/challenge
- empty rows in range
- How this function is read?
- Code to tranpose table
- Checking the existence of a reference workbook
- How to delete row if column is blank or certain text
- syntax for range selection
- validation help with drop down
- Need Excel to use a 5 Day Week
- Does a worksheet exist?
- Deleting blank values from an array
- Removing Cell/Row Values Condition
- MultiSelect Popup
- Chart DataLabel Alignment / Word Wrap
- undo date format questions
- Grabbing text from just part of a cell
- VBA conditional formatting
- Macro to save Excel file with date and time in the file name?
- VBA: Group Pivot Table and Combo Box
- Excel and VB6 COM -- Isolated Error 438 & 430
- Single command to toggle a Boolean?
- Macro for opening new files and copying from them - please help!
- Street numbers
- About going through all the cells in a sheet....
- Positioning Numeric Values Resulting from 6 Column Array Formula
- Customizing FaceID options
- how to catch a value in the format like "0E085"
- Select Case Question
- Excel Spreadsheet 10.0 - Scrolling Down - HELP
- Extract selective data from a spreadsheet
- HELP: print macro woes :S
- Linking if-statements in a macro to different workbooks in Excel (using VB)
- Excel: How to create a form to search for rows in another sheet?
- Subtotal database based on column with faked date
- Box to select printers
- Highlighting cell if content is duplicate
- Essbase Combobox
- Page Breaks in Excel
- Replacing dots with commas using macro
- Max/Min for variable length columns
- change type of a file
- Can you share a personal macro workbook
- Deleting duplicated values
- copy worksheet
- VBA to open .exe file
- Determining if a named range exists
- Intellisense does not pup up?
- How To, Drawingobject Text Boxes:
- Macro That Deletes Columns
- Table to Table
- Automation on a spreadsheet
- Error locking cell
- Excel to SQL db
- Vanishing Command Buttons
- Looping macro needed to find intersections of rows and columns
- Notification upon submission of data?
- Listview Question
- Reseting controls
- Unique identifier
- change type of a file
- Code error!
- Progressbar during the CalulateFull execution
- Macro copying cells between sheets
- I am using visual basic express edition 2005
- create function with passing parameters
- extracting data
- My excel buttons and formulae disappeared after running macro
- Copy Rows from one worksheet to another by entering the Name of the Staff
- User Defined formula, selecting range
- Newbie Question - vlookup, I think
- Trying to append to file using an array
- Convert a string value to numeric and sort
- formatting dates
- searching a large database with a long list of search terms
- Making the drop down list of a cell depend on another cell
- NEED A INVOICE PROGRAM THAT REMEMBERS VENDOR'S NAMES, ANY IDEAS?
- This is embarrassing - I lost my Macro recorder button!
- Adding Numbers
- deleting worksheets corrupts files
- Strange CPU deadlock in very short macro
- drop down that refers to another drop down in excel
- rename all files in a folder
- Setting visible range
- Userform problem, bordercolor not changing around images
- setfocus in textbox on multipage
- "Show Placeholders" in options/view menu does'nt work.
- "Show Placeholders" in options/view menu does'nt work.
- range average code
- Convert Adobe Acrobat (RDF / PDF) file to Excel through code
- Inserting Last Date Modified in Footer
- Randomization of groupings based on value
- VBA - Text To Columns
- QueryTables command
- calculating hours
- ControlTipText in a ListBox, doesnt refresh
- Get Relative Data from result of MIN function
- Adding a Chart Datalabel with a Webding
- using personal graphic for faceid
- identify little squares for Alt Enter
- Multiple Menus
- Loop in Excell with VBA-code.
- Finding duplicates in list during UserForm entry process
- how can i use the ISNA and Vlookup funtions in a macro?
- Sort problem - part2
- Clearing cells
- VB to produce a record of all files in a directory
- Breakpoint ok, no breakpoint messes up...
- Sumproduct to count
- VBA Referencing a cell
- Excel Add-In Release/Test Procedure
- Excel Add-In Release/Test Procedure
- macro to change date ranges
- Macro for button - copy and paste rows
- VBA dynamically format Row1
- How to reference list using a drop down menu, displaying the list
- Subscript out of range error
- Looping to fill ListBox
- access excel control from vb.net
- ASP Page not opening a new Excel Spreadsheet each time.
- ASP Page not opening a new Excel Spreadsheet each time.
- Project Unviewable???
- Copy Specific Cells depending upon cursor location in Excel
- External database causing problems?
- drop-down list changing according to choice made
- activating cell which is in rowMatch, columnMatch of two given val
- if & and code problem
- Is there anyway to do this?
- Entering variables on Msgbox prompt
- Shell & VBA
- Copy Paste Macro
- Copy Paste Macro
- Suppressing Remote References Problem
- No duplicates in column
- subtotal based on ref no
- Creating Loop to Paste Array
- Moving left/right from active cell
- Line Wrap Problem
- Renaming Invalid Defined Names
- Global Names Issue
- Why these commands make erros? (Breaklink and SaveAs)
- Linefeed character creates runtime error in Sweden
- Reading Active Directory from VBA?
- Filtering merged cells
- Average if
- find sum in list of of numbers
- Range names are created with the English format : for ex. _15_Feb_06
- No permit dupes in listbox...
- sql query from excel
- Activate Workbook
- what if the configured proxy server does not connect
- Find Macro across workbook
- User form - print Landscape
- Multiple tests for a condition
- Transpose rows to columns with varying numbers of lines per record
- a macro to run for each file in the same folder
- a macro to run on all the file in the same folder
- Filename from the result of a Filesearch
- Different Behaviour of Public Object Vars in Worksheets vs. Add-In
- Setting Cell Type From Word Macro
- reading data in to Access From Excel
- Macro Path
- Import Macro
- Multiply Y ases Scales
- Windows Common Controls
- how can I assign a password to a command button
- Concatenate Macro
- How do make a macro activate the next sheet?
- A Mirror Copy of a Sheet with Different Outlook
- "Delete" method of a worksheet object
- Importing into Excel from FileMaker
- Comparing Cell Value With A Reference
- Quickly determining whether any values in a range are empty
- Value# in VBA script with reference
- Modify a macro
- Ensure single class instance but with multiple references to it
- copy 1 array to another array
- Excel Web Query not working!
- Microsoft Error Report - Excel with VBA
- Find, Copy and Paste question
- SQL Select Statement in Excel
- how to select a Row based on contents of a Cell
- UserForm ComboBox RowSource Problem
- How to Copy a project plan to Excel through macro or batch file?
- Unhiding specific worksheets in VBA (Excel 2003)
- help with a formula for counting
- Opening worbooks with a variable file name.
- Import External Data Macro
- Repetitive Spreadsheet Formatting Automation
- Prinout function
- Multiple Range Selection
- Delete an image from the cell
- Can't programmatically set a large array string to a range.
- Selectionstart
- Mac Excel for 2004 macro date problem
- Substituting cell content into a formula
- "Record Macro" toolbar in Excel 97?
- "Record Macro" toolbar in Excel 97?
- Update a range within a macro using an input box or similar
- how do i program excel to add two times together
- visible zeros
- Runtime Error Paste Method of Worksheet class failed
- Set the selected range myrange
- Combine a Dlookup with DMAX function
- UserForm1 not getting removed using VBA
- Interop problem with VS.NET 2003
- Simple Find Text problem
- How can I automate filling in a Web form with Excel data?
- How to reverse data in an Array
- Help: Converting Pluses and Times to Sum and Product Functions ???
- displaying data that does not meet criteria
- Learning Excel programming
- Input$ Userform
- Print Macro V
- Lookup/sort values
- Excel 2000 GETPIVOTDATA
- Why is my macro looking for the original file I created it on?
- How do I isolate the Fractional part of a number in Excel VB?
- Userform button setting variable from formula
- Userform button setting variable from formula
- Filling an array with a Loop
- Cell fill color. Row to match specific cell.
- Excel bugs? Experience with paid ($245) phone support from MS?
- Excel Viewer for Windows ME
- Same code - different results
- Show Modeless Form
- Protect sheet
- VBA Macro to Clear Named Cell Contents
- Intelligent picture cropping
- Workbook Open Event not triggering
- How a function can modify a value from some cells ?
- Subtotals
- Print Macro
- Concatenation problems...
- Setting a maximum field value to 100%
- Problems on Protected Sheet
- Updating a database table
- need assistance with some find or lookup related code...
- Set MyRange for non-adjacent cells and iterate through?
- easy solution, just cant remember how to
- getline from a macro
- Closing a referenced workbook
- Problem with Excel Header/Footer from .NET ???
- Highlight text in textboxes
- Need some help please
- Can I place "On Error GOTO xxx" into module level?
- Userform data retrieval
- How do I copy selected cells in excel and paste into word table
- Sort of a problem?
- Range - select row
- Application GoTo
- can i use sumproduct this way in VB?
- Help with SaveAs prompt
- Dynamically changing font size of combo box
- Display a macro at top of macro list?
- keypress
- Max Max
- VBA - naming modules
- Excel Date Problem
- Trendline Coefficients
- Would like to retrieve data from spreadsheet to userform
- Horizontal sort??
- Add macro to excel toolbar from worksheet
- Sort by Alpha, ignore blanks
- to open a pdf file from a macro in excel
- Clear events scheduled with Ontime method
- little help: "quick comment"
- Finding a match and removing if found?
- Distributing a workbook app with References
- Specifying table in Word then creating it in Excel
- Range address from Excel in C#
- Printout
- Using Excel function with variable
- Difine a range with variable
- a question
- Why unable to set cell's ColorIndex property?
- Can't seem to find the error with this code
- Moving The Selected Record From One Sheet To Another
- Rename Multiple Sheets - Help with Mr Dave Peterson's Code
- Formula problem in code
- Run time error (Copy Method of Worksheet class failed)
- Tracking client contacts
- workbooks.open function fails to open an existing excel file when used in ASP, but works in VB.
- Basic forecasting and scenario comparisons
- Question about PivotTable
- calculate date diff in a cell
- Error trapping for the Form_Activate() event
- Save a variable value outside a macro
- Collection from Range, tag cells on error
- HOW DO I USE THE GETSAVEASFILENAME METHOD?
- VLookup or other?
- Cells.Find method and Boolean operators
- Changing a constant
- Variables and graphs
- http address for shared files in web mail
- ListBox Click...
- new green cell comments in Excel 2003
- Passwords etc
- Moving Rows Up - based on contents
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.