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 |
- Two Quick Questions
- Conditional listing & double selecting
- color of comment lines in vba
- copy & save desired data to a new file
- Counting by colour dilemma!!
- How to format text in a Text box using VBA code
- Need some help and explaination. Thks.
- Two Quick Questions
- Please help with code
- A VERY SIMPLE UserForm
- Import partial record from text file string
- find and delete text, find a 10-digit number and put it in a textbox
- Locals Window - Extracting Contents
- Populate Combobox in VBA form from worksheet - Tricky
- Cleaning up some VB
- Auto execute a macro if a cell value=1 ?
- Pesky Autofilter Toggle
- Populating a spreadsheet with Stored Procedure
- A VERY SIMPLE UserForm
- Memory Leak in C++ Excel RTD (same as in VCRTDServer)
- A Print Button macro that is based on Checkbox macros
- Auto Fit
- Filter by cell color
- A VERY SIMPLE UserForm
- Help ASAP myRange
- copying and skipping consecutive row data
- Repost: Any way to do this with a range?
- Code works within VBE but not from Excel
- Find Correct Subdirectory
- Error Message When running code but not stepping through it.
- compare student data over time
- Executing a formula?
- Please help.. lost in code.
- How can I delete a row based on Columns H and I
- Please help.. lost in code.
- Using a combo box to populate rest of a table
- OWC Message
- Limit text input in Excel 2003
- How can I delete a row based on Columns H and I
- database to store data entered from a spreadsheet?
- Programmactic access to Visual Basic Project is not trusted
- Can a workbook funtion without a missing dll ?
- Changing the Path In a Usage Log
- testing post .. please ignore
- drop down lists embedded in cell
- Setting HorizontalAlignment with VBA
- Autofilter - storing parameters
- Conditionally format
- Macro Security Setting not applying
- workbook contains automatic links
- Help: Cells.Select
- Please help.. lost in code.
- VBA killing my named ranges
- Script to locate unique reference help please
- Call other application from excel
- Installing Solver.xla in all computers by default
- Link to original cell, it is possible?
- Convert time cell
- Format of a msgbox
- .ChartArea.Fill.UserPicture PictureFile:="how to reference an obj.
- Simple Java script within the hyperlink
- VBA Excel 2000 issue
- Displaying an image without using external files
- populate Access numeric field with nothing
- Propagate labels from Worksheet
- MISSING: Analyze Timescale Data
- A Macro for copy with selection.. (please help me)
- Displaying an image without using external files
- help with sorting
- Please help.. lost in code.
- Hyperlink Headache
- Function
- Dynamic range
- 2 strange ones..
- Copy Entire rows with a difference
- Copy Entire rows with a difference
- Formula
- Please help.. lost in code.
- Hidden Range
- auto run macro on workbook open
- Formula Yields Slow response
- Copy Entire rows with a difference
- Label Scroll Bar Properties: Make Visible?
- Need to use an offset for x-axis in chart/graph
- Data comparison showing detailed output
- Character and number in a cell - Can you help?
- auto run macro on workbook open
- use of worksheet function average in VBA
- How to draw lines to seperate data
- Auto execute a macro if a cell value=1 ?
- Need to use an offset for x-axis in chart/graph
- link to word
- 2 Questions about code with excel 97
- More efficient method to copy-paste values in place?
- detecting open excel apllications and api qn
- Passing a range in a macro call
- Is there a formula that can pattern match?
- dictionary
- find result - only for expert
- Vba excel - autofill
- run time error 424
- Displaying an image without using external files
- Help with .Add specification
- printing via vba
- copy part of row
- add three parts of text with one date into a string
- reference to range in function within code
- RTD server stealing focus
- Displaying an image without using external files
- Copy Cells formats to another workbook
- macro help for a beginner
- Match Flies
- Blinking Cell
- Picture Viewer - Copyright Clearance
- Extract keyword from a string
- add three parts of text with one date into a string
- Scope of the arrays in Loops
- txt2xls
- macro help for a beginner
- Object-defined error???
- Can this be done? Excel output page problem.
- reference to column (not known) and certain row number
- How to format text in a Text box using VBA code
- Automatic page break
- Page break
- add "line" in a message box
- VBA - Find every occurance of string in workbook, write to 1st she
- Insert named range problem
- vba:Userform
- tutorials
- Creating A Trade Date Column
- Selecting a group of sheet tabs
- Excel addin problem
- InputBox vs. UserForm for Numerical Data Input
- Auto execute a macro if a cell value=1 ?
- Help with link
- Re: I have 15 floppies, I want to know the file names, worksheet n
- Checking cell for Dependents
- Finding CurrentPage in PivotTable
- ComboBox processing error
- run macros against protected cells
- Go To Location
- InputBox vs. UserForm for Numerical Data Input
- Error Handling Problem
- ado connection to access vs. sql server?
- XML
- Reading more than one set of data from a single cell
- Pop-up box..I think.
- Excel worksheet tabs
- Programmatically delete macro using a protected project
- getting cell value with all format without paste
- MsgBox Screen Position
- column sums
- run time error 424
- Capture network login ID
- column sums
- column sums
- Detecting Symbols in Textbox
- Create list (exluding blanks) from different fields?
- run time error 424
- VLOOKUP
- InputBox vs. UserForm for Numerical Data Input
- Mail Sheet as message body
- Microsoft ProgressBar Control Version 6
- Rows in a Range
- Delete multipage
- Subtotal function with Criteria
- macro help for a beginner
- Control Arrays
- Checking cell for Dependents
- Create arrays in macro?
- macro help for a beginner
- translating worksheet formula into VBA
- Copy/Insert Rows Help needed
- Using Excel is a SIN ! ! ! !
- ListBox index question ...
- Copy Multiple Selections thru Code
- setting column value based on if statement
- Conditional formatting?
- Mystery objects
- Password Prompt for VBA Project Appears After Excel Quits
- Upload file to the internet
- Checking cell for Dependents
- COmbo box and lookup list
- Hyperlink browser position
- Hyperlink browser position
- Run a sub or function on program start?
- inserting pictures
- Run a sub or function on program start?
- How do I print only the cells I need?
- InputBox vs. UserForm for Numerical Data Input
- Creating a Macro
- VBA List Worksheet Functions
- Copy Range
- Pesky Autofilter Toggle
- Creating Multiple Reports, One by One, for a List of Names
- Textbox question
- Using Excel as my database
- class events stop firing with ADO 2.8
- append 2 cells, delete old
- Column reference
- Missing VBA modules
- Password Applied to All Worksheets Confrimation Prompt
- Inserting .bmp image using VLOOKUP
- Sheet Compare Macro...
- Help with using the SUBTOTAL formula in a macro.
- Converting to seconds
- Importing external data
- Last Cell
- Reading Rows of Variable Length
- Microsoft ProgressBar Control Version 6
- conditional format?
- How do I auto-number rows in excel?
- InputBox vs. UserForm for Numerical Data Input
- Range Filtering
- copy part of row
- add three parts of text with one date into a string
- Checking cell for Dependents
- Autofit Comments
- copy part of row
- Checking cell for Dependents
- What statements introduced in what XL version?
- Converting to seconds
- Linking labels to cells and turning off events in userform
- To put value from txtbox to cell?
- enter value line by line
- Deleting/highlighting duplicate rows
- ADO Connection to ORACLE 9.2 through EXCEL fails
- Having a formula reference a a range
- print and save a single sheet from a workbook using a commandbutt.
- routine to convert to date format
- Linking labels to cells and turning off events in userform
- VBA to match Cell Colour to another Cell
- Cannot calculate
- Transpose after finding criteria assistance needed.
- The dreaded Sendkeys command
- Error Accessing File
- Convert values in a variant array to integer values
- IF Statement and VBA
- Button Code to Alternate Sort Order ?
- Getting a Cell Value from another workbook
- How do I check modifications of file on server
- Copying the entire sheet if columns H & G are equal to row.
- Spreadsheet function that mimics "LIKE"
- how-to use Excel to upload records to a MySQL database?
- 2 Questions about code with excel 97
- Combo boxes 101
- append 2 cells, delete old
- How copy specific range from one sheet to another using a Macro (V
- commnd button - when i rt click, "assign macro" isnt an option...
- VBA for Evaluating Integrals
- Module runs twice
- Formatting cells
- Combining Non-numerica data from multiple sources
- updating links to a password protected file
- how do I program for a 'generic' worksheet to open
- VBA to match Cell Colour to another Cell
- How do I link drop down menus to one another in Excel?
- More on my Coding Impasse
- Long Time Delay To Update NewsGroup
- How to create an add-in (xla) to load up my macro so it can be available to all users
- Copy/Paste Row
- How to draw lines to seperate data
- Excel Range issue
- excel template?
- Downloading image and placing in cell.
- Password Applied to All Worksheets Confrimation Prompt
- Excel 2000 - Function call causes Locking up/Crashing
- Select workbook with variable name.
- vb value to cell possible?
- Change of workbook procedure
- Macro to initiate a spreadsheet to email
- Excel Range : Row limit
- Coding Impasse
- InputBox vs. UserForm for Numerical Data Input
- get new file name when refreshing query
- How to prevent my Macro from opening up another Excel App when I open any other excel file
- if x = true then do y, possible?
- Excel VBA Newbies - Is there a better syntax to code the if
- 6 cells into 1
- Learning Macros and ActiveX controls...have a simple question...
- VLookup problem
- Problem about Form....
- help with sorting
- Coding help
- InputBox vs. UserForm for Numerical Data Input
- Protect/Unprotect ALL and/or SPECIFIED Worksheets in Workbook
- COMBO BOXES
- Lotus Notes/Export to email
- How do I check for a range name within Excel using C#
- Test for file existence
- Regional Settings with VBA - Urgent
- CheckBox and ComboBox controls move on previewing or printing
- "Last Changed By" Cell
- moving contents of cells based on criteria
- Command Button Anomaly
- Need help i moving one worksheet to another
- Test for file existence
- MapPoint Colors
- Difference between Select and Activate
- MsgBox Function and Arguments
- Is there any VB command to find out the total no. of days in a month?
- giving cells a nice color
- Can macro build new macro in another workbook??? Pleeease HELP
- VBA to linking data between two workbooks
- VBA and Business Objects
- Getting row numbers of a filtered dataset
- Msg Box Help
- Select Excel Range from Access
- Why does my code run but have no effect?
- Calculating days until an event
- Import excel tabel whitin Word into Excel
- MsgBox Function and Arguments
- Spurious decimals
- sheet code problem
- Find/replace macro
- Users printer list/ Dialog for print NAME
- InputBox vs. UserForm for Numerical Data Input
- VBA to match Cell Colour to another Cell
- Skipping blank cells in a column...
- Personal.xls "Before Print"
- unprotect VBA error
- How do I get data from one cell based on the value in another?
- Preventing Customization
- visible sheets
- getting cell value with all format without paste
- Add line between previous and current cells . .
- Solver VBA control
- "trap" a compile time error
- reset menu captions
- Msg Box Help
- Automating a data checking routine
- Preventing Customization
- advanced filter using VBA
- CDATE issues
- .Copy Destination:= .PasteSpecial ???
- PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets?
- Users printer list/ Dialog for print NAME
- Essbase + Excel + VBA
- Open, print and close workbook
- InputBox vs. UserForm for Numerical Data Input
- Find, Findnext VBA Loop
- Excel and Access
- Printing a Word document from Excel spreadsheet
- Excel and Access
- Macro newbie
- MS Excel 2003 and OpenOffice Spreadsheet
- Paste link and more
- Accessing a Text Box in a Word Document from Excel
- running vbs script from vba?
- Syntax To Insert A Number Into One TrxtBox If A Different TextBox Has A Date That Is => 1/1/98
- One Frame, 10 Charts, 10 Macros?
- Vlookup question?
- Convert number into text
- Format Columns
- permutation generator help.
- Referring Objects
- Changing the Protection prompt
- User Input Of A Number
- Optimizing a macro for speed- find and replace
- run time error 1004
- Way to by pass PW to hide sheet
- PrintPreview Question
- Add worksheet named as a date
- Newbie Pls help
- What formula can look in multiple workbooks and create a master l.
- sorry i put wrongly for padded leading 0
- padded leading 0
- User Input Of A Number
- Change information automatically since excel to powerpoint
- macro to create a worksheet for every name on a list?
- Conditional Formatting Not working (xls 2003)
- Counting and Summing with VBA
- Excel 11.0 Object Library
- form problem
- Optimizing a macro for speed- find and replace
- Counting and Summing with VBA
- Javascript functions in Excel output page
- Linking Chart directly to VBA function returning 2d array
- if x = true then do y, possible?
- Hide row macro
- Apply passwords to open on multiple files
- VB Script to remove row
- VB Script to remove row
- Hiding Columns
- Solver VBA control
- Looping Question
- Help Using Click Event
- Data Validation
- ADODB Question
- Out of Memory?
- Checking a userform for blanks
- macro to append one cell to another
- display data from a website in excel that requires a username/password
- web toolbar auto opens
- VBA ODBC connect to DB2
- worksheet calculation-anybody please
- Finding multiple occurances of a date within one column: Should be easy?
- Read And Write On A Closed Wbook
- Finding multiple occurances of a date within one column: Should be easy?
- Workbook in a Server
- Trace Precedents of Conditional Formatting
- Help with autoupdate....
- macro button
- Finding multiple occurances of a date within one column: Should be easy?
- Input Box
- Help with VBA on IF Then Else
- VBA to match Cell Colour to another Cell
- EXTRA large checkbox and labels.
- Help with an error
- Loosing combo box ListFillRange
- If Then Else looping problem
- batch convert worksheets in one workbook into csv files?
- Find method, After parameter
- Help with my excel spreadsheet
- Workspace faux user-defined type not defined
- Help with Custom Function
- Help with autoupdate....
- macro error
- Disabling Min and Max buttons in Excel Worksheet
- Finding multiple occurances of a date within one column: Should be easy?
- Deleting rows with #N/A
- Macro problems
- paste data to cells from html select box
- Find and Replace formatting inside of a macro
- help with sorting
- Problems usinga a variable in a worksheet function?
- Help with Custom Function
- Can macro build new macro in another workbook??? Pleeease HELP
- VBA to match Cell Colour to another Cell
- Paste Formula
- Merging two books
- Date specific Macro
- Copy & Paste Drop Down Box with Macros
- Create new Excel file
- Worksheet function
- Open, print and close workbook
- Adding quotes to the ends of a string variable
- Extracting specific data from cells
- VBA to consolidate multiple worksheets to 1 worksheet in running sequence
- Problems usinga a variable in a worksheet function?
- Recovering from temporary loss of network drive - Excel VBA problem
- User-defined Error Values
- Workbook open event
- VBA to consolidate multiple worksheets to 1 worksheet in running sequence
- run excell macro on add-in menu
- Extracting specific data from cells
- Importing tab delimited files into Excel
- Problems usinga a variable in a worksheet function?
- unique vaules
- GUI Expert: Excel-based User Interface or OO User Interface?
- QUI Expert: Excel-based User Interface or OO User Interface?
- OnAction calls to subroutine
- Copying sheets without code
- permutation generator help.
- Defining a variable within a sub...
- run excell macro on add-in menu
- Defining a variable within a sub...
- VBA to delete rows in certain order
- Open, print and close workbook
- vba - need simple function to delete ranges
- sending mails using outlook
- Add line between previous and current cells . .
- Conditional Formatting
- ¶¥¼¶×ÔÖú½¨Õ¾ÍøÕýʽÍƳö
- Formula '=IF'
- Simple beginner question
- Writing dynamic code - problem with VBA project protection
- Using a saved query to retrieve data from different sources
- Combine files
- run-time error 6 - overflow
- nomber of lines
- Defining a variable within a sub...
- Conditional Formatting
- Array Problem??
- Open, print and close workbook
- Capture Dynamic Range address into Modeless Form
- Calling of functions
- VBA to delete rows in certain order
- Capture Dynamic Range address into Modeless Form
- Dim MyArray vs. Dim MyArray()
- copy workbook
- assigning array back to range
- Simple beginner question
- Counting by colour dilemma!!
- User Input Of A Number
- sum cells based on multiple criteria
- Setting the Help 4.0 file name and path in a locked project
- copy range from each worksheet to seperate workbook
- copy range from each worksheet to seperate workbook
- can i reduce an array to size of 0
- Merge a list into a cell
- Open workbook with x number of sheets
- VBA to delete rows in certain order
- Macro Help
- Addin reference
- concetenate a single cell with a list of text in a text box into .
- Checking if an Excel file is empty?
- copy range from each worksheet to seperate workbook
- HELP: Access table linked to Excel - calculated fields?
- Format() doesn't work from a Form
- When Wanting To Replace Previously Saved .xls File
- Conditional Hide rows with zero
- Automatic Macro Execution Upon Cell Values Changing
- Deleting #N/A
- providing a sheet-copy event or copy CustomProperties
- Hints for working with budget and register excell worksheets
- Macro for Printing Only Displayed Data
- autorun upon activating a sheet
- How do I insert a row below the active row?
- selection.find shortening the procedure by skipping the "activate" part
- Counting Unique Entries Wit a Twist
- hiding the Menu bar
- HTML Questions
- Opening Outlook calendar files in Excel
- HTML Questions
- nobody seem to have answer! pls help
- how to delete to the end of line
- Calling addin Function from another workbook?
- hiding the Menu bar
- Create new Excel file
- Object Orientation / atpvbaen.xla
- Weird SQL Question
- Calendar Control - Display Issue
- Newsgroup problems...
- Creating a Macro that will Delete if anything less than 20%
- want a break in line graph
- Object definations/help
- Time delay function
- Bypassing OK/Cancel Dialog Box
- VBA: Look-Up Cell Date From User Input Box and return ALL matches
- AutoFill difficulty
- autorun upon activating a sheet
- Excel VBA Newbies
- Bypassing OK/Cancel Dialog Box
- Help! Bug-esque code behaivor on Windows 2K Server & XL2K
- Help with increment problem please
- Need Help using Max in a Vlookup function
- Need to beable to create a folder
- Bypass Msgbox from external vendor's Add-In
- Two Macros at the same time?? is it possible
- printing time literally
- Selectively Copying Information to a subset
- URGENT MACRO REQUIREMENT!
- open file, then call macro... won't work
- Macro Help
- Beginner VBA question
- Force Macro to wait till Refreshall is done
- Duplicate Record....
- Automate Worksheet
- Preserving data formatting when using VLOOKUP
- Separating workbook name from extension
- Macros stored on Personal.xls
- Find ActiveCell.column
- macro that loops till end of worksheet
- Unable to set the NumberFormat Property of the Range Class - ERROR
- Assign Macros to a dropdown list
- Conditional Formatting with more than 3 conditions
- macro to loop till end of page
- Userform: Combobox, dates, match required- can't get date format to work
- Pass Variable Question
- Selectively Copying Information to a subset
- For loop for each file in a folder?
- Error trapping
- Excel VBA: Subtracting TIMES
- Timed Interval Data Entry
- Open file on a specified Worksheet
- Force Macro to wait till Refreshall is done
- Excel VBA: Subtracting TIMES
- question about toolbar corruption
- Password Protection
- VBA: For Each... Statement, Expert?
- Insert Picture into excel
- For loop for each file in a folder?
- Preserving data formatting when using VLOOKUP
- Inserting .bmp image using VLOOKUP
- Pasting into an Autofiltered Block
- Excel 2003 graphics are invisible after loading xla
- Row must equal one of the following, or be deleted
- VBA arrays
- exit from a loop?
- Range
- DDE Startup Hangs
- DDE startup Hangs
- DDE startup hangs
- Range Filtering
- maxif function in vba
- Dinamically reference Acrobat Distiller?
- ###Error 57121###
- Excel function troubles
- Elapsed time to run code
- Assigning the Help 4.0 file path in a protected project
- Copy Paste Merged Cell Format
- Can not digitally sign
- simple formula
- Range Filtering
- hidden rows when running a macro
- Userform setfocus problem
- Err.LineNumber
- programme variables in excell VBA
- how return to last used sheet?
- hidden rows when running a macro
- efficiency qn: search collection or use on error?
- searching column "A" then Moving Right
- Worksheet in form
- convert number to text in Excel
- Err.LineNumber
- rank
- Time calculations in VBA
- Simple beginner question
- Time calculations in VBA
- Conditional Formatting of Scatter Charts
- Breakpoint in Worksheet_Change sub
- Simple Worksheets update
- how to upload csv to excel?
- Simple Worksheets update
- Time calculations in VBA
- Multiple Target as Excel Range
- How to make VBA code to self-destroy itself?
- Duplicate Record....
- export favorites into worksheet
- Time calculations in VBA
- Copy and Paste from Excel into Outlook Email message
- macro to append one cell to another
- ToolBar
- Help AutoFilter
- import and export vba
- How to create pivot tables using c#
- Checking whether a worksheet exist or not
- User directed graphing?
- InputBox Screen Position
- Beginner VBA question
- Just Excel VBA
- Position chart
- Copy sheet and strip all vba codes
- cells...
- VBA: For Each.... wont work correctly / is placement wrong?
- TO MODIFY A EXCEL OBJECT FROM WORD USING VBA
- Cut and Paste using Macro gives paste special method error
- Removing already used values
- Counting by colour dilemma!!
- In Excel,VBA. I need help to name a range.
- change the value of togglebuttons
- Macro Help
- CFPlus - v1.01.090 - Error 5
- Using add-in in VBA with another module?
- Using add-in in VBA with another module?
- Hiding Userforms
- Row must equal one of the following, or be deleted
- Borders
- how do I create drop boxes
- Excel Won't Quit
- Using add-in in VBA with another module?
- Add ability to excel to create dynamic drop-down(CTRL+L) lists us.
- Extracting data type from variable
- limit to possible array size?
- Exporting VBA DataForm Info to Word document
- Array of Arrays in VBA
- Referencing Excel.Chart.8 OLE Object in Access Report
- checking if a range has a name.
- How to save a new excel sheet using C#
- Using a cell reference in a filepath
- Combining Cells
- Sort list
- How do I have VBA return the trendline types possible for given d.
- Comments and Sorting
- Scrolling with wheel in combobox list
- Data logic/brain cramp
- Control Arrays?
- Re: I have 15 floppies, I want to know the file names, worksheet n
- Restoring Links
- How do you use the text command in an if statement ie. if....,tex.
- Checking existence of array dimensions
- writing to files
- turning auto calculate on and off
- Grouping without totals
- Barcode Scanner and macro question
- Retrieving Value From Column A
- run time error '1004'
- Bulk Row Deletion - Fastest method
- GOTO a Part Number
- Annoying Dialog Box
- ASP Dynamic Excel Creation
- Inserting .bmp image using VLOOKUP
- Automate Excel and Navigate Worksheets
- Reading long strings (with jdbc) from Excel
- Set reference to other sheet?
- macro to scan list
- Excel 97, text box Input Mask, local date format
- dec2bin
- Tab Order
- XL2K: How to reference workbooks that aren't open?
- Problems usinga a variable in a worksheet function?
- how do I set and arrange the tab order for text box objects
- Error when moving sheet
- range referencing
- Restricting access to data
- Sorting A-Z then AA-AZ etc
- WeekNum Trouble
- dec2bin
- Populating dropdown list 2 with data depending upon what was selected in list 1
- range referencing
- range referencing
- emulating xl consts
- Option Buttons and List Boxes
- Combining a MS SQL / ORACLE Query
- Bulk row deletion
- Range selection
- Error when moving sheet
- Open file on FTP location
- How to draw lines to seperate data
- wingdings characters and codes
- Macro to copy data
- how do I get the tab name into a cell
- Macros fail if file saved in another location
- ANNUITY PAYMENTS
- Change the font size for Row numbers
- Automatic Button Delition From Worksheet
- combo box empty after using .AddItem
- Rows to be moved from one flag to another flag
- Write Data from Control on a Windows Form
- Checking cell for Dependents
- How to insert: " into a string
- Cell Comment Summary with Hyperlinks
- Public Variables
- question about forms
- Problem with Excel97/Chart/Formula
- Report
- array length in VBA
- question about forms
- Counting by colour dilemma!!
- getting selected text
- Newbie Question - Excel VBA
- Import excel tabel whitin Word into Excel
- Duplicate Record....
- Excel 2003
- Problem activating OLEObjects
- Reading the separator from the regional settings in Excel 2002
- Select Inverse
- Retrieving data from Excel and store it into string variable
- Multiple Sorts
- Help with Commands and Syntax please.
- addins and vba
- Creating Workbook with 2 worksheets
- Add Barcode
- Recovering from temporary loss of network drive - Excel VBA problem
- please help
- import access into excel
- Re: Conditional Compilation using Application.Version
- Checking whether a worksheet exist or not
- show all changes of shared workbooks
- xlCellTypeSameFormatConditions
- Access table to Excel
- EXCEL close event?
- Comments and Sorting
- Retrieving data from Excel and store it into string variable
- Requesting formula help for dates/years
- refreshing a treeview control.
- Re: Option Explicit and Date Format "dd mmm yyyy"?
- Click Checkbox Event
- Copy & paste simple problem
- Simple VBA problem
- Read cell value and display
- Need some help and explaination. Thks.
- Getting KeyPress Event to work
- Easiest Way to do this Importing method?
- about worksheet
- Need some help and explaination. Thks.
- using ADO for database in sheet
- pivot table more than 1 column?
- Re: Problems usinga a variable in a worksheet function?
- Problems with Multiple Instances of User From
- Retrieving data from Excel and store it into string variable
- Referencing a general Cell(i,j) in an Add-In
- How do I check cells using index in Add-In
- help with debug "drop down calendar"
- Re: Copying a sheet, but preserving the formulas
- Re: List with Input Box
- Subtract based on Ending Time
- Re: Recovering from temporary loss of network drive - Excel VBA problem
- Re: Printing objects
- Re: Status bar event ?
- Re: Conditional Compilation using Application.Version
- Re: Autocopy row from several worksheet to another workbook
- Query/formatting problem
- need macro to output quatation mark...
- Changing right click menu on worksheet?
- Problem with calling addin macros in ExcelXP
- Problem with calling Excel2000 addin in ExcelXP
- Run Macro When Any Cells In Sheet Change
- Re: How to draw lines to seperate data
- Barcode Scanner and macro question
- msoFileDialogFilePicker but for directories
- Hiding controls with rows
- Trendline values display
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- Place Comment into a cell
- RE: How To Delete First Record In A Text File
- "Sum" function as Macro
- delete rows
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- Re: Call phone number in Windows XP
- Re: Protect from copying cells or worksheet
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- Re: exit from a loop?
- Counting by colour dilemma!!
- Subscript Out Of Range Error?
- Synchronize pivot tables
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- vba: How do I write a "For Each Statement" nested in a "With Statement"?
- Barcode Scanner and macro question
- Re: Refreshing Autofilter
- RE: ActiveWorkbook.Sheets.Count
- prevent cells to be mark
- Re: How to eliminate spurious data in a string?
- Do using range vs. row iteration?
- RE: Is this possible?
- use variable as connection in query table?
- Format Today function
- Re: prevent cells to be mark
- Re: Can Not Insert Object
- Re: create a sheet but hiding it
- change active sheet
- "Sum" function as Macro
- array: subscript out of range
- Re: Default File Location
- Is this possible?
- Deactivating auto macros
- Re: Counting by colour dilemma!!
- Excel COM function list.
- Freezing a bottom row
- can share vba script using different workbook?
- How do I 'save-as' with an add-in .xla?
- range and cell
- How do I 'save-as' with an add-in .xla?
- How do you read a text file into Microsoft Excel 97 visual basic
- change function variable prompts??
- Saving in VBA
- Pinda
- Creating a template in Excel using VBA
- import access into excel
- Cell formula Help
- Cell Formula Help
- Using a result in the same formula.
- What must I do to get gridlines printed for both filled and empty cells?
- Using A Macro To Name A 2-dimensional Range
- Get data from cells on different worksheets
- Crash on Mac with Office v. X: characters.insert
- Resize and resample pictures inserted
- Dynamic range offset problem!
- Edit mode
- inserting images in excel
- VBA Code to copy a worksheet to another Excel Workbook
- How to input file name in user form
- simple formula
- Summing durations
- Can you get a log of the "thread" of lines used, when your macro run?
- User Forms data entry - MM/DD/YYYY
- Find All.... Then Select All
- How to hide rows and/or columns using a formula in excel
- Dealing with pop-ups
- Insert Mult. Rows
- Large project ideas, maybe should use Access?
- Conditional Formatting
- How do I insert a macro to fax using XP fax without fax wizard?
- Lock & Protect Cells With Data
- Iterating Thru Cells
- command?
- too many macros
- Excel macro problem on 'value' method
- Project still in "project explorer" window after file closed down!
- convert pxl to text
- form creation
- Importing a csv file
- Getting the sum of rows.
- set error
- Assign ID based on condition(criteria)
- Turning hyperlink warning off
- How Do I Get SetFocus To Work???
- Copy a value to the next empty cell in a column
- Find method, After parameter
- Change the color of an Excel Macro button?
- Help with sums
- How can I sperate the module into two part and connecte the two part and work well?
- automated continuous adding
- Saving using VBA
- Cell address
- Ado / Adox ?
- Using A Macro To Name A 2-dimensional Range
- Crosstab in memory
- 424 Object required error
- Ado / Adox ?
- Excel MAcros
- SUMIF Question
- Excel logical operator for a cell if another cell has a certain co
- open and hide
- Excel formula, 2 colons query to sum values in colon 3
- Inline formatting
- Ado / Adox ?
- Recommended reading DLL's VBA
- AfterUpdate
- using multiple dlls
- How to debug a VB dll used in Excel
- UserForm Question
- File Size Too BIG
- VBA MRU List
- unlock and lock VBAProject
- Filter/Advanced Filter
- Re: Forcing worksheets to be closed first when user trying to close excel
- How can I protect objects differently?
- Going through each item in a sheet
- Going through each item in a sheet
- Going through each item in a sheet
- Re: Going through each item in a sheet
- disable right mouse click on "Worksheet Menu Bar"
- Going through each item in a sheet
- Going through each item in a sheet
- Going through each item in a sheet
- Going through each item in a sheet
- Going through each item in a sheet
- Sql Refresh
- Going through each item in a sheet
- How do i select the first cell in a sheet
- Jump to new line after the first record is displayed
- Jump to new line after the first record is displayed
- use of function <target>
- Re: Jump to new line after the first record is displayed
- Jump to new line after the first record is displayed
- Excel macro to add /'s to a cell value.
- Tutorial and Excel and Access
- Jump to new line after the first record is displayed
- Presentation of my macros -how to in powerpoint
- Accept on condition only !
- import huge text file line-by-line?
- Help With Conditional Format
- Jump to new line after the first record is displayed
- Re: Jump to new line after the first record is displayed
- Cut & Paste with hidden columns
- Repost! Excel multiple worksheet populate from recordset
- Creating Multiple Reports, One by One, for a List of Names
- Input mask for userform textbox
- VBA - Help with Code (see message)
- VBA MRU List
- Delete Date data macro
- exit while?
- Why cell colors change when copying/moving
- How do I set up macro in VBA to choose worksheets?
- Printing Variable Length (but Not Width) Range
- reformulation question
- put on a eliptical fit for x-y points without a, b, e or the othe.
- Range Offset Error
- Validate values for Whole Number only
- Ado / Adox ?
- Text Comparison
- VBA: Text Box Property (MASK?) (Easy Question)
- VBA MRU List
- Find Hard Coded Cells
- Calling Procedures in other Projects
- Variable Reference to a Form Control
- WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
- this workbook before print
- Bitmap data of Image controls & Picture objects...
- Excel/VBA Programming
- Find method, After parameter
- Deploying Office Web Components 9.0
- VBA - AfterUpdate TextBox
- Move Copy sheet with cell having more than 255 characters
- Ado / Adox ?
- VBA and Validation Lists
- Selection to Array then unique with different fields/columns like advancedfilter
- Selection to Array then unique with different fields/columns like advancedfilter
- Iterating thru cells & comparing
- macro help...
- PrintOut workSheet
- Auto macro
- "Document Recovery" grey commandbar
- Some menus don't work opening xls in IE 6.0
- VBA Userform Textbox re-writing cells in Excel
- using Criteria with two possible values
- Starting add-in using vba
- Sendmail
- conditional insert image in a cell
- Trouble with Macros Assignment- anyone willing to help?
- Inserting sheet name into a cell
- Opening csv in Word
- Excel Add-In for Analysis Services and embedded Excel OLE object i
- treeview and laptops
- Text Comparison
- Help - applying macro to all files in folder
- Is column hiden?
- using Criteria with two possible values
- range referencing
- Run a macro shortcut from another macro?
- How to disable the Application Dialogs>
- Trouble with Macros Assignment- anyone willing to help?
- using Criteria with two possible values
- Deconstructing an add-in
- convert csv to normal Excel file
- using Criteria with two possible values
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.