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 |
- Instructions within VBA Functions
- Annoying Pop up box in function
- Calculating the difference between hours
- Resources
- Formatting problem Excel
- Is there a macro function to find out if a cell contains a functi.
- macro help
- File Already Open Error When Executing A Macro
- Emptying cells containing a single blank
- Deleting a row by a column value
- Resources
- Data access using ODBC datasources
- Re: Trusted Security Tab
- ActiveWorkbook.EnvelopeVisible = True
- File Already Open Error When Executing A Macro
- Trusted Security Tab
- Annoying Pop up box in function
- MyHelp - VBProject.Helpfile
- Allow certain users to edit certain rows?
- Annoying Pop up box in function
- Previous Worksheet
- Declare Variable
- Calculating the difference between hours
- Multiple users using a single userform
- Annoying Pop up box in function
- Instructions within VBA Functions
- SheetList - Help with skipping sheets
- Instructions within VBA Functions
- Formula as User Defined Function
- Environ Function
- Trigger a sub when cell changes?
- new sheet ops in macro
- Instructions within VBA Functions
- replace a string in the worksheet
- Declare Variable
- how to export a function from a vb6 activex dll
- Declare Variable
- Instructions within VBA Functions
- reloading a userform query
- Clearing user forms
- Get rid of some message about macros.
- Pivot Reports (by date)
- how can I format a .csv file from external data?
- Remove digital signature with VBA
- Is workbook / sheet protected
- How do I autopopulate data in excel?
- How to automatically populate using Macro
- Object Numbering
- Ranking issue
- VB runtime error codes
- Require extra funtionality - existing code included
- Critbinom
- End Double Sub
- Introduction in file Send to
- User Defined Function - Title
- Commenting in Code
- Help
- Public variable defintion (newbie)
- sorting code problems
- Automatically update column - Autofill
- Help with Calculation
- Automatic change for time constraint
- ToggleButtons are strange
- AutoFilter
- Declare Variable
- Cell value controlled by button
- Using AND to eliminate IF statements
- Testing If password is being cracked?
- Colour Cells depending on time
- linking spreadsheet nightmare
- Selecting Workbooks
- TXT file to Excel
- Print preview in a user form
- Sage Excel Link Error
- How creating a color listbox in a cell?
- calculating undefined ranges using vba
- Pasting into a row specified by a value in a cell
- Centering the text in a message box
- Define Object Variable
- dfgdfgfdg
- Post from Excel?
- test
- dfgdfgfdg
- Pasting into a row specified by a value in a cell
- ADO - accessing oracle
- Better help in VBA for "NumberFormat Property"
- Access worksheet by name
- username & password check
- Pivot table - 256 character limitation?
- Reference not responding
- Access worksheet by name
- Test for char in string & separating if present
- Multiple Userforms at once
- Data From Two tables using SQL
- Excel formula - overwritten files and data
- VBA IN AUTOFILTER
- Extract data
- Macro to open all linked workbooks
- Simple Case Of Protection
- Saving file to compressed folder
- intermittent problem with clearing textboxes on forms
- SUMPRODUCT for 3D values
- SHARING MACROS VIA ADD-IN (.xla) FILE
- Read/write a Serial Port
- Trouble with worksheet_calculate
- Public variable defintion (newbie)
- Sending Personal.xls Files To Multiple Users
- Autofilter
- Macro Design Help
- VBA and Goldmine (DBase)
- 8th Order Polynomial Trend - Is there an easy way?
- linking spreadsheet nightmare
- sort cells with spaces to the top
- Macro: With Stop it works. Without Stop it doesn't.
- Click event to run only once
- Multiple print areas, one worksheet -need to print to PDF!
- Range question
- Range question
- Access Mask equivalent?
- How could I get the client's browser to refresh an HTML spreadshee
- protection annoying - how to fix it
- Visual Basic File selection
- Need macro to autofit height for merged cells
- Form & combo box question
- web spreadsheet
- Change it from 7,6,5,4,3,2,1 to 1,2,3,4,5,6,7
- Validation problem
- filtering resp. today()
- CTRL+SHIFT+END
- Mail to multiple receipients
- RP or TO - Add all files EXCEPT active file?
- Allow certain users to edit certain rows?
- Protection
- Hidind rows conditionally
- Is there a function to convert a string representing an integer i.
- PasteSpecial
- Runtime error 380: Could not set the List property. invalid property value of listbox
- VB6 Excel 97 code no longer works if Win2K SP3/4 applied.
- Problem creating a macro
- Evaluating Empty Cells
- Excel visual basic
- What is best method of filling in fields on an MS Word Document?
- Control Button is still selected after macro runs
- SHARING MACROS VIA ADD-IN (.xla) FILE
- how do i use R[]C[] notation in Excel visual basic
- Declare Variable
- Menu attached to a form?
- Vba printout
- PrintArea
- Can Anyone Solve This One, Please, From Liz
- Get Module line # for error trapping
- Allow certain users to edit certain rows?
- Variable results to new workbook
- Declare Variable
- long time to create toolbar in excel 2003
- does workbook contain worksheet
- Evaluating Empty Cells
- vba search
- PrintArea
- How do I make a value required in a cell in Excel? ex: Name, Last.
- VBA Excel
- Using add-in through intranet
- New Sheet
- Preserving Row Height with Paste Special
- return all worksheet tab names and chart sheet tab names in report - an example
- Hide shapes (buttons) before printing
- Run-time error ‘91’:
- Maintaining Macro Toolbar Button Properties
- Lookup List
- Calculating the difference between hours
- Duplicating a Workbook
- Paste txt to word
- Allow certain users to edit certain rows?
- How to make a more interactive spreadsheet?
- Another avoid the loop trick request - on fast fill (Maybe an Alan trick)
- # of Spaces macro
- Calculating the difference between hours
- Feet and Inches
- Macro to change list box input range based on selection made in another cell
- Custom Number Format for Feet and Inches?
- error handler in macro?
- Determine elapsed time between two dates
- Notification from Excel VBA
- Sheet selection
- Macro selecting rows.
- Resources
- Protect the sheet
- worksheet_change event fires multiple times
- how to find last row/col index within a selected range
- Refer to Range Name in Page Header
- preventing / converting 'illegal' characters in file-save text string
- Signaling the presence of a password
- Resources
- Unfilled data worksheet
- How to show/hide sections of a userform?
- Reference Library - Missing Library in a lower version.
- Protect the sheet
- xlodbc returning no rows & no errors
- Creating Directories
- Duplicates
- Calculating the difference between hours
- Keeping a workbook hidden when opened via VBA???
- "IF" syntax
- CellColorIndex - not working.
- Change event
- emailing attaching active workbook to it to myself
- macro loop
- Saving work sheet
- unprotect VBAproject, change library refs?
- IF statements
- CellColorIndex - not working.
- CellColorIndex - not working
- date format in excel
- my message in Status bar
- User defined functions
- Default formatting settings
- Excel Visual Basic Project Explorer
- VBA Automatically Changes Cell Format?
- Keeping a workbook hidden when opened via VBA???
- Current Row number
- Text Box Calculation
- Textbox calculation
- Enter Symbol showing on worksheet from text box entry
- Cell outlines missing
- SQL Keyword
- How to record a sheet change showing row column sheet name and date?
- Sql Table Join?
- match and/or index
- PivotTable After Refresh Event???
- Can I run a macro/program when Excel saves worksheet?
- checking variances in cells
- Copy Code
- How to set series data in VBA
- Copy Data
- Enter Symbol showing on worksheet from text box entry
- How to record a sheet change showing row column sheet name and date?
- macro not ending
- How to record a sheet change showing row column sheet name and date?
- Need Urgent Help Please
- Check Drive Space
- Excel formula: select value in column if condition in 2nd col met
- "Stop" not working
- How to record a sheet change showing row column sheet name and date?
- Colour Cells depending on time
- Automatically update column - Autofill
- do .... loop
- Make a Cell Act like a Button
- Worksheet_Change method not working in Excel 97
- Open as template only
- Open as template only
- Loop through selected cells
- Creating Trainees with macros
- Sending Personal.xls Files To Multiple Users
- Inter-process handling
- Dialog Boxes for Excel Program
- Software of scripting to grab data from MS word file and fill in Excel fields?
- do .... loop
- activecell
- Checkbox List in VBA?
- Change all text in a column to uppercase
- Can anyone help me figure this out?
- Colour Cells depending on time
- Click event to run only once
- Check for DLL Reigistration
- do .... loop
- Testing for existence of a worksheet in the active workbook
- Filter and copy
- XLA auto_open
- Deleting XLA codes ...
- computer name find
- cell values
- Run Time Errors
- Removing records from entries that begin with *.
- remove assemblies on save?
- Renaming macros...
- Shading cells based on Other Sheet Value?
- Custom Windows menu
- Hide colums based on dropdown list
- Need Help with executing a function based on time.
- Forcing an input in a pop up box
- Im so close. Need variable range for the pivot table
- code for printing
- RE: Run-Time Error 1004
- Retrieving Dropdown/Option Button Values
- Histogram / Count Programming Problem
- Code To find and run an EXE file out side of the Excel
- using a input box
- Macro to replace * with /
- Filename with date and time
- Sending Personal.xls Files To Multiple Users
- display long number as text
- Copy referral $ sign to other cells
- Copy referral $ sign to other cells.
- Percentile Value
- Clear contents if x is not in the row
- Parsing a String to get Numbers
- changing image control's picture path
- Parsing a string to retrieve numerals
- Retrieving Dropdown/Option Button Values
- Pivot table Programming
- clipboard pop up
- Nedd Help with an input box
- Using a macro to save a file.
- Excel auto-start macro
- xla add in issue
- Microsoft Jet workspace
- Validation
- Create macro to download access 2000 table to excel 2000 spreadsheet
- worksheet_change event fires multiple times
- Disable/ Enable Macro
- Compare Cells on Sheet to ListBox Selection
- Wanted: Data Analysis Workbook
- A Question about Listboxes
- Add-In
- Date Formatting in Code
- Protect Cell Formatting
- Conditional Filtering with cell format
- Macro to copy cells one row up then move down 4 rows & repeat
- worksheet_change event fires multiple times
- Format a Filtered range's header?
- Message prompt in VBA
- Wanted: Data Analysis Workbook
- Moving 'Closed' Rows
- How do I set up a template to assign a unique number?
- CELL FORMAT
- Run-Time Error '91'
- Looping
- How Do you Change The Color Of The CommandButton That You Just Prshed
- VBA Macro Help
- Transforming Excel data to Xml
- Centering the text in a message box
- Help !!! Pivot Change with Parametric data
- (Follow-up to earlier sort question) Further help required
- Macro to delete blank rows
- Looping
- TextToColumns Destination:=another worksheet
- Re: Array(arglist)
- moving table to next page
- VBA Macro Help
- Storing a Macro name in a Variable
- Add a Spreadsheet to a VB Form
- Copying worksheets across workbooks
- Linking check boxes
- Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement
- NumberFormat question
- Creating PDFs from Excel VBA
- excel vba
- Sorting by date
- .Net and Excel 2000 Protect
- Application / Object Error 1004
- Automatically update column - Autofill
- How to simulate worksheet rename event
- MATCH values on a subtotalled worksheet
- excel vba
- Auto ReCalc
- Macro Design Help
- Get data for only last three months
- Closing file and excel
- MoveAfterReturn is tricking me.
- On close and before save events.
- automatically insert rows
- Usage of Find function in excel
- Sorting based on a cell
- inputbox function
- Moving to another cell
- Excel Cell Select
- Excel Cell Select
- Sorting based on a cell
- Excel Cell Select
- Sorter macro
- How to record a sheet change showing row column sheet name and date?
- Sorting by date
- Random Draw
- Any quicker ideas?
- Re: Sorting by date
- Excel Library
- Make code more economical
- Catching NewSheet-Event in another WorkBook
- inputbox function
- Sorting by date
- How to record a sheet change showing row column sheet name and date?
- Insert code by code
- Sorting a value based upon the values that appear in row A
- Sorting a column regardless of whether a value if + or -
- If statement and Macros
- Using a range with SUMIF
- Add scrollbar control
- Scrollbar Change event
- Scrollbar Change event
- How to make a list of all shortcut keys
- Inter-program communication using SendKeys
- update a txt file if dta is new
- Get data for only last three months
- more than just conditional formatting
- Concatenate
- Using a Macro to Sum a Variable-Length Range (a Column)
- First Aid For Macros
- Accessing a non-active sheet from a userform
- Hide rows when quantity is zero
- Continuing Difficulties W/ Sum For Variable-length Column
- Chart links for copied sheets
- First Aid For Macros
- Problem with Excel plug-in
- How Do I assign a numeric value to a text entry?
- How do I link a .xls invoice to an access database?
- Continuing Difficulties W/ Sum For Variable-length Column
- Ungroup Sheets
- Using a Macro to Sum a Variable-Length Range (a Column)
- can it be done without notice
- Must be better way...Using Listbox Selection to Query Data
- Help With Autofill
- Drop Down List in Inputbox
- Getting values from a variable sized range into an array
- auto save on exit while at the same time rename workbook...
- Hi,
- Filter/copy based on criteria
- Drop Down List in Inputbox
- Click event to run only once
- How do I publish a Excel chart using vba macro?
- Code to change interior colour only if current interior colour is
- Automatically Parsing Fixed-width Text Import
- Open only existing Excel Files in a given Range
- multiple versions of Office references
- Excel Filesize
- system error when inserting UserForms
- GetObject function
- Re: Excel Window Zoom Problems
- Date Comparison in Code
- How do I modify a SQL connection string in an xlt file from a VB6 app?
- Worksheet events
- Identifying Pivot Table's Field
- can it be done without notice?
- Looping thru a range - storing IF not blank?
- Manuals
- Saving to Text problems
- Events, Class, Time Editing
- Excel VBA printing to MS Word cause MS Word to crash, why?
- VBA - MS VB Compile Error
- list box
- File Reference
- Use variabel as reference
- creating database from excel spreadsheet
- Directory Browse/Search information
- VBA - MS VB Compile Error
- RP - Add contents of cell A1 in all workbooks within a folder
- Rounding Entries From Range to Array
- Copy Excel Spreadsheet formula to a range via VB6
- Autofit
- Date Comparison in Code
- VBA - MS VB Compile Error
- moving table to next page
- creating database from excel spreadsheet
- Moving to another cell
- help with Pivot table
- Moving to another cell
- Re: Concatenate Textbx(s) Content HELP
- VBA - MS VB Compile Error
- Open only existing Excel Files in a given Range
- Adding a command button
- Filling command button with image
- selecting a file automatically
- "save changes pop up"
- Code Livelinks - Please help!
- Macro execution from Excel IF function
- Comment for ComboBox & Command Button
- Linking Button to a cell
- Hide Tab in TabSheet on UserForm
- Grouping Cells
- identify currency and do sum
- Calculating the difference between hours
- run macro in VBA code
- Insert rows in depending on criteria in variable columns
- Newbie VBA questions
- Drawing on userforms
- Calculating the difference between hours
- Pivot linked to large Access DB...help!
- How to referance a GroupName
- Re: Concatenate Textbx(s) Content HELP
- Error following Microsoft Article
- Formatting Questions
- Delimiters recognized by ADO for Text Files
- Looking for network-username with Excel macro
- Calculating the difference between hours
- Linking Button to a cell
- Check variance code not working
- copy multiple unkowns
- Assigning the Help 4, *.HLP file for a project programmatically in a protected Project
- Get data for only last three months
- Conditional Formatting in a Loop
- Calculating the difference between hours
- Getting dw20.exe error while openning excel formatted xml file
- savecopyas question
- Get data for only last three months
- Date problem
- Calculating the difference between hours
- Macro Help
- Get data for only last three months
- Mouse scroll in user form list
- Disabling Macro-Virus check
- range value with variable not working?
- for each loops
- textbox in a macro
- VBA Sub procedures
- Remove missing reference programmatically
- Locked VBAproject due to macro fault????
- Limit working area of a sheet
- Sorter macro
- dropdown list in an excel web page
- macro names not consistent?
- Disabling Macro-Virus check
- Create an EXE file.
- Disabling Macro-Virus check
- splitting names & email add.
- Locked VBAproject due to macro fault????
- Locked VBAproject due to macro fault????
- Not a valid Add-in - Error Message
- Tausendertrennzeichen
- Get a value from a table in an HTML document
- Accessing Mutiple TextBoxes
- Removing all Toolbars in one line
- macro with checkbox(i)
- Converting cells to data file
- VBA Macro Assistance (I am desperate)
- Option Button->Format Control->Cell Link...
- Protected Shared Workbook
- Printing part of userform
- >> Updating Links
- Using a Macro to Sum a Variable-Length Range (a Column)
- Urgent Help needed - On Formating a page
- Defined name range
- Average For Variable-length Column (w N/A value inside)
- Unprotect worksheet error
- Average For Variable-length Column (w N/A value inside)
- Defined name range
- Continuing Difficulties W/ Sum For Variable-length Column
- Close Dialog Box with SendKeys
- Excel - how can i reference a table using vlookup?
- Close a MsgBox
- VLOOKUP into a closed xls using VBA
- Help with a macro
- Change Cell from Validated List Not Firing Worksheet Change Event
- Path
- Worksheet events
- Path
- EXCEL HEL URGENT
- comparing data in different workbooks
- converting fractions less than 1
- Find Extents of Data
- Many spreadsheets to one with many tabsheets
- highlighting cells if value is repeated
- Re: Learn French in the Alps.
- highlighting cells if value is repeated
- Application.OperatingSystem Unix
- Unprotecting a Sheet
- Continuing Difficulties W/ Sum For Variable-length Column
- VBA Macro Assistance (I am desperate)
- Naming of MsgBox Buttons
- Sending Personal.xls Files To Multiple Users
- Focus sheet
- Continuing Difficulties W/ Sum For Variable-length Column
- Automated sheet copying and naming
- How do I create a logfile
- How Do I program Excel to Source a Database
- Continuing Difficulties W/ Sum For Variable-length Column
- Using a Macro to Sum a Variable-Length Range (a Column)
- Modified VB Code for Converting Number to Text
- Hide all menubars even 'Worksheet Menu Bar'
- Wish to apply "Save Preview Picture" in 300 files.
- looking at a cell before reffering to a table
- Splash screen and various screen resolutions
- Application defined or Object defined error
- Calculating the difference between hours
- looking at a cell before reffering to a table
- Calculating the difference between hours
- Function Help
- Function Help
- Help with Code
- referring to columns/cells using numbers
- retrieve data
- variable scoping - constants going out of scope - circular references
- Updating records in another workbook
- Printing A Chart
- How to check if cell value is displayed as hashes?
- Strange looping behaviour and Error 400
- Vba and excel, userform help
- ActiveX Controls loose left position after printing/preview
- Find the largest number
- HOW I CAN CONVERT NUMERICAL INTO WORDS IN CELL
- Copying from one SHEET to onother with the condition...
- Modified VB Code for Converting Number to Text
- is there a hotel management excel app.?
- Re: Naming of MsgBox Buttons
- Provide increment and decrement buttons on toolbar line
- different workbooks
- Allow formula access to the row/column information in the Name Box
- Using a Macro to Sum a Variable-Length Range (a Column)
- Problem copying checkbox values
- Function/Procedure dependence & order of execution
- Solution for ComboBox Code
- Define Name Truncates Formula?
- Advanced Filter Range Selection in VB
- Advanced Filter Range Selection in VB
- Edit this macro
- input data from 3 workbooks into a fourth
- retrieve and update data from a dbf file
- Simple userform help
- date cell from lotus is not working
- Can excel remove the duplicate rows in a spread sheet?
- Chart Title as a Cell in a worksheet
- not getting the "assign macro" shortcut
- AppActivate & Internet Explorer file download
- fmMousePointerHourGlass not working
- validation
- Query Hungs up Excel
- Edit this macro
- format cells with ### as number, then convert to string showing date.
- Macro that stops at a mid point occasionally
- Help with a macro
- On Close Macro - stop warning message
- Using Ranges to input variables to UDF
- Daily Analysis Report, Charts do not update Automatically.
- DAO Recordset in Excel
- difference between comm control on win 98 versus windows xp
- Help with a Form function please
- (new to the group) importing data into excel and printing
- Learning VBA Which Book?
- How Do I Detect An Entry In A Range Of Cells
- Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP)
- Help with IF
- Automatically close a userform
- Macro or addin for changing Number to words
- Finding A Desciption In Another Book
- Automatically close a userform
- Unable Export Data to Excel on Win 2000 Server
- Office Object Libraries
- stop execution
- Automatically close a userform
- Using IF in a macro
- New Range containing Unique names only
- Autorun a code when any cell is changed in a range
- Sub, module??
- changing cell format from number to percentage
- Macro to open other applications
- How do I automatically import CSV data on startup
- Zero Decimal Places
- Serial port interface
- chart in userform
- select all arrows or lines on active worksheet - an example
- copy multiple unkowns
- How do I automatically import CSV data on startup
- Send a String to a Web-Browser Window Using Macros
- Pasting records into Excel with QueryTables
- Auto Close Grouped columns
- Making macro functions invisible?
- Ending Sub
- Date spilt into four cells
- VBA new function doesn't execute
- skipping pop up box for saving changes when closing a file
- Search and replace
- sockets in vba
- Subtracting Dates in TextBoxes
- A question about textboxes
- Remove part of string
- Add contents of A1 in all workbooks within a folder
- renaming worksheets with a macro
- run time error 13
- A question about textboxes
- Run time error 13
- Macro for comparing two spreadsheets
- Excel 2003 won't fire Excel 2000 Macro
- Macro to bypass password pop up alert
- Import Picture from disk...
- VBA and F2 programming question
- VBA new function doesn't execute
- How do I test for the first character
- RangeExclude function
- Accessing Mutiple TextBoxes
- How to add images to a Combobox.
- Four digit numbers need to be split up
- Coverting dates
- Help creating a shortcut key.
- Sheet Name Character String
- Run Auto Close when Excel Closes
- Pivot Table Error 1004
- Excel 2003 - 'CopyFromRecordset' Error
- Object error on an Option Button
- Newbie, msgbox
- Number to Time
- Auto Close Grouped columns
- Deleting Rows
- RT Error 1004, Select method of worksheet class failed
- Clean up code.
- program control
- Deleting Rows
- Four digit numbers need to be split up
- Anyone see the prob in this code?
- Accessing Mutiple TextBoxes
- Link Formulas
- Is a sheet a worksheet?
- MSForm 2 - Creating labels and text boxes at run time
- End of previous month
- IMMEDIATE window
- Anyone see the prob in this code?
- MSForm 1 - Initial placement of form
- Custom View - TEASER
- User Input to open multiple files
- PDF FILE CONVERSION
- How do I keep a running total of time?
- Inline Carriage Return?
- 0x800A03EC, asp and excel export
- Remove letters from a cell
- how is the syntax to replace a date, recorded within a macro with a cell value ?
- Sorting regardless of whether a value is positive or negative
- Summing
- Accessing Mutiple TextBoxes
- assign variable
- Search
- Open File Variables
- Excel macro
- PivotTable
- Running cade on new file from template
- format caption
- Values from bold cells to combobox?
- Error in Copying and pasting data
- PivotTable programming help
- scroll bars in userforms
- Excel doesn't allow comments to be copied
- about more controls of a form
- Printing several worksheets as _one_ print job
- Combobox & Display
- How to obtain sum of odd numbered column
- filter on pivot table grand total
- printer selection
- List all comments in a workbook, by sheet and cell
- Using an array to select data
- stop code execution with button
- ADO Recordset to Text File
- 2003 Excel VBA on XP runs very slow vs Win/Office 2000 - why?
- Conditional Formatting Forumla
- Need help killing a remote Excel
- How to find speicial cell using macro
- Guru Help Needed
- Comparing two workbooks
- Moce rows with N in Col A to a new sheet
- how to return the value of a cell based on two criterias in two columns
- Filter/copy based on criteria
- unique entries code
- macro to filter sheets
- how to return the value of a cell based on two criterias in two columns
- Close without "Do you want to save changes" prompt
- Excel VBA - open text file, replace text, save file?
- VBA new function doesn't execute
- Click event to run only once
- Worksheet_Change procedure question
- How do I test for the first character
- Input Box - UPPERCASE lowercase
- Need code to insert cell value
- how do I get the current cursor position in a spreedsheet
- What is exel formula for future value of savings using constant i.
- problem with vlookup
- need code to insert cell value
- Problems with ADODB
- how may I copy color of a other cell
- MakeTable of Contents with VBA
- How do I test for the first character
- Help with a macro.
- Which rows contain certain text?
- How do I automatically import CSV data on startup
- problem with beforeclose event
- Help with Form function macro
- Printing same page twice with a subtle change
- Switch to worksheet view
- Using a Custom Function - determining the row that called it
- unique values
- can I call a worksheet function from within vba?
- How do I test for the first character
- Printing same page twice with a subtle change
- Close Workbook After 10 Minutes
- Check variance code not working
- Linking Combo Boxes
- Delete all files within a folder (incl subfolders)
- Creating VB OCX that uses MS Excel, but not always
- Converting Text files to Excel sheets with specific formatting
- Printing Word Document using Excel Programming hangs Word
- Copy a file into multiple dub-folders
- Forcing Save As: dialog box
- Anyone know of a Solver tutorial?
- How do I test for the first character
- webb visitor list - any methods to convert search engines query strings?
- Excel Macro
- Trim spaces on both sides
- Minimal Excel UI
- Little help with merged cells
- Can this work???
- disable conditional formatting
- MsgBox formatting
- Macros to run on a timer
- Need help with printing macro
- Printing same page twice with a subtle change
- Extract Number without quotation marks
- Converting 9/30/04 16:30 to minutes only
- Adding to Dates
- Check variance code not working
- "Status" indicators
- Email
- how to place formula to cell
- password protect vba code
- How to disable autoopen() programmatically
- Marco Run on File Close
- Application.Dialogs(xlDialogFormulaFind).....HELP! !!!!!
- Exporting to Navision
- Column listed as "Number Stored as Text" - Exported from Access
- Report Headings
- Download
- Equlivelent to .NewIndex Property in VBA Excel ?
- Semicolon problem
- how is the syntax to replace a date, recorded within a macro with a cell value ?
- sequential number based another cell
- positioning a comment
- Progress Bar
- Alternative to send mail
- Error 1004 Application Defined or Object Defined Error
- How to unload a form in excel vba?
- VB.Net to Execll
- Re: Last Row
- Printing a Word document from an excel macro
- Printing a Word document from an excel macro
- Bolding
- VB Code to Delete Unused Rows
- Macro , Unprotect-Protect -- Atten: Tom Ogilvy
- Saving an Embedded Excel Sheet in OLE Control
- Web Query Changes Format to Scientific in Excel
- statement to Exit Do if empty row
- dynamic chart
- coding worksheets for undesired selections
- Deleting a row based on the value in column A
- Inserting column headers
- Semicolon problem
- Max of integer vals
- Print Userform???
- Print Userform?
- Data validation question
- Cell Reference
- cell protection
- OLAP Reports
- Protection
- Semicolon problem
- How do I override a deletion box?
- Error only without references
- vlookup with VBA
- VBA to select multiple columns
- Get cell's print sheet #
- using For each loop to populate a range
- First text box in form not working right
- Array selection stopped working???
- .Find method not working???
- If Condition
- solver constrains in macro
- Highlight row
- Problem with Looping and Output
- reading data from com port into 2 different cell locations.
- formatting the view of a worksheet
- Workbook
- Change Cell Colour
- Error 1004 when pasting - Hair pulling time
- VBA in Excel: How to keep relevant rows only?
- Copying from excel to txt + formatting.
- how clear up this problem
- Excel 2002 - 2 problems
- Open Helpfile from Excel VBA or hyperlink
- Need func to display a cell + formatting in another cell
- Validating data in a spreadsheet control
- Validating data in a spreadsheet control
- Issue in Cell Value Alignment
- To: Harald Staff with Rgds to Your Code
- Click event to run only once
- Can you help with the correct translation of this code?
- strange prob: file not getting closed after vlookup
- Excel compiler and Excel password
- Text to columns -- reset delimiters, etc
- UDF, Array function, vertical output
- Cell Manipulation
- variable in excel
- Performing codes on different worksheets
- Add 2 more criteria's
- Toggle datafield in Pivottable
- Average
- Cell Manipulation
- Testing for Cell Validation
- Just Curious
- Moving between a cell that is selected to include a range of cells in that row
- Activate/Select Problems
- recvery msg and excel shut down
- Change named range value
- Extract Cell Comments?
- Max of integer vals
- syntax help
- InputBox Function & Cancel
- Print some Sheets
- Pasting formula with defined name
- Anyone know of a Solver tutorial?
- E Mail from Excel using a command botton
- accessing custom document properties without loading file
- How can I have a macros automatically run when I open up the file.
- Filename Function
- Make a Change to Code
- Combo Boxes and Tick Boxes
- Using Add ins for files downloadable through web
- Why ask for a password?
- Default path
- Disable Control in Tools Menu
- vba checkbox
- xOut
- formulas after insert row
- Open current database method
- Trying to delete macro -- 'reference is not valid'
- Re: pesty "Compile Error!"
- Trying to delete macro -- 'reference is not valid'
- excel macro
- Trying to delete macro -- 'reference is not valid'
- Unable to read file
- copying entire column
- Reference to Office 11.0 Object Library
- Filling cells
- GETPIVOTDATA
- Delete Empty Rows @ End of Template
- How do I create minimize and restore buttons on a user form
- to: Tom Ogilvy (Find and transfere values)
- Creating list of sheet names
- subtotals in a protected worksheet
- Problem Recording Macros in Excel
- Disable Message Prompt in VBA
- Re: pesty "Compile Error!"
- how to get a macro to run when the file opens
- C++ and Excel : Need Simple Charting Example (I can populate sheet with Data)
- Creating list of sheet names
- Query Results to UserForm
- Drag and Drop with Charts
- Extract Number with zero
- Drag and Drop between ListBoxes and Excel cells
- Method to pause VBA?
- Re: pesty "Compile Error!"
- HELP! cell validate
- Query results to message box
- Paste Command
- Executing code based on changes made to a form ?
- Problem with formula in cell
- Need help with empty cell in Macro
- User initiated break/actions during macro execution
- Range("A1") Question
- camera tool causes drastic slow down of macros
- Transpose Range
- Reference to sheet name in addIn
- VBA and F2 programming question
- deleting worksheet code in generated workbooks
- Excel Macro/Assembly i created in C# wont load on End user compute
- Prevent user disabling events
- Extract char from multicells to build new in another
- blank cell
- empty cell?
- URGENT! check if cell has only ALPHA chars
- VBA and F2 programming question
- .NET component won't show up in toolbar or menu
- How to modify excel setting using VB.Net
- IFBlank Formula
- I need a simple excel formula
- Method to pause VBA?
- Using formula to extract info
- change colour on value, 4+ colors
- Pass Version of Excel to a variable
- Disable/Protect Cells based on If
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Code to change the color of "Rectangle21_Click"
- Excel automation in VB.net
- Autofilter Multiple Criteria
- Macros
- Is Workbook read-only because of file permission or because file is already opened?
- Defined Names revisited
- Starting a macro based on cell value
- Use macro to check a range of cells within a row and copy wanted data to new sheet
- Help Please with Error 91message
- as that was so easy...
- Pass Version of Excel to a variable
- Click-event question
- VBA Functions acrosss multiple version
- Detect which UDF params was chnaged
- How to check if cell contents overflow.
- Time-interval protection
- Search and Replace With Formatted Text
- How to use macro to run excel, word, powerpoint, outlook, IE, etc?
- auto pivot tables and charts ?
- Union Method with multiple worksheets
- Auto fill
- textbox formatting
- Autofilter Multiple Criteria
- Excel2003 and xlListSeparator...
- strange behavoir
- Changing colors
- Convert no. to time
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.