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 |
- ListBox (?) in a macro
- View Excel Charts on Web Page
- Worksheet Lookup Problems
- How to see how many lines of code ?
- Need help finding text string in an Excel file
- Links to another workbook
- Strange problem....excel not responding
- convert to decimal degree from DMS
- Find/replace [Zx] with [Znumber]
- Rows to repeat at top Except for the last page
- Send email
- ORDER IN WHICH LINKS UPDATE
- extracting email address from Outlook
- Automating Linear Interpolation
- Border cells with less code?
- Active Range?
- Import multiple csv files into current workbook as separate sheets
- Testing of a workbook is in read only mode
- MOVING A VARIABLE RANGE
- HELP! Macro FAILS when I copy the worksheet...
- Loop Through textbox in Excel
- How do you Lookup data on different worksheets
- loop through textbox in Excel
- Providing status info during UDF calculations
- [URGENT] How to Trap Excel Window Scroll Events in VSTO
- Worksheet Change Event With Validation List
- Advanced Filter Error
- Export to Tab Delimited Text Error
- Including blank rows in a series of comments (sugarthebeet)
- Named range expansion by date??
- Blinking text if....
- Delete a range of rows ?
- Simple VB code
- execute a macro from within an if(,,) function?
- Save to hard drive and backup to thumb drive.
- weird problem when using MS Query from Excel
- Word.Range
- Excel Work Sheet Protect
- Array Coding
- Change cells color & cells contains if formula
- bug: Excel cells lose format after a "replace all" function
- Filesearch problem
- IDE autocomplete
- combobox change event is running when enable events is false
- Dialogue box check boxes
- Run macro when cell is highlighted.
- Count equal numbers in beginning of a column
- Reffering code to command button on diffrent sheets
- help with an IF formula
- VB: date format in an Excel file
- beforeUpdate event of Web Query
- excel protect method
- Naming a worksheet as a variable in a Active Chart Series
- Problem saving Excel file in HTML format
- upper case default in comment box
- Count periods in a cell
- readystate for an IE window that was not created in Excel
- Combo box and Worksheet_Change
- Removing non numeric rows
- coun problem again
- Body message - email
- paramete web r query
- How to Call a Store Procedure!!!
- Increment Macro - Order numbers
- Documentation
- Appearance of sub Accounts when put curser on main account
- IsText VBA Error
- Not enough memory ,message
- Show FolderNames on a list
- VB can't find my For loop???
- need to compare between 2 tables
- Checking Input box
- Moving Parsed Text from Rows to Columns
- what takes precedence between change and selectionchange?
- copying cells by checking color of the cells
- From 1 worksheet to another
- A general question about editing current list via UserForm
- Addressing Question in Excel Macro
- how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?
- Finding the first non-blank cell in a row and then applying a calculation
- Book request
- how to making to project group
- Change the path of a Microsoft Query?
- if i wanted to learn VBA in excel what would be the best course?
- Excel 2000 Code works except in debug mode
- ActiveWorkbook.SendMail - Message body
- Validate email address
- Reference to Libraries
- How do you I link a drop down box with a scenario macro?
- Data Labels Overrun Each Other
- save e mail attachments and remove them
- Confused, again! Object variable not set?
- Protection
- Error Messages
- OleObjects and someproperties
- Shapes
- Printer Tray
- Adding Cell Comments from TextBox entry
- How parse out characters from long string?
- Passing a range to a function
- Run Make table query from Excel
- loop to insert sequence in column
- Cannot find Cell
- Custom Function Tips
- Loading Excel sheet into Web component
- I can't get my macro to run!
- Hide/Unhide with passwortd prompt
- Copy from active sheet and paste into new sheet using info from cell in active
- What's wrong with this macro?
- Print duplex
- Easy one? Is there a "When" like argument?
- Flaging up an alert
- forms / text boxes
- Move items into weekly calendar
- Making records from captured cell data
- Set up Universal Macro
- REFERENCING cell reference
- Need help with Listboxes!
- Can you capture worksheet double click event from an Add-In????
- Macro Help...
- Range Problem #2 (continued)
- Protecting Sheet Disables Tab Key
- My Macro stops
- Range Problem
- getting strange error in formatting chart objects
- How to write a formula with a user defined function
- SUM in VBA
- Cycle through worksheets and sum
- Macro Forces a Check of Data Validation Before Saving or E-mailing
- Mailing from excel
- clear data from selected cells
- Forms - Verify date format
- Sum up all cells that contain a color
- need help with hyperlinks
- copy paste with key shortcuts
- Round function
- Server name in Excel file path
- Conditional Copy and paste
- Copy sheet without macro
- making a checkbox appear and disappear based on a cell's value
- Reformat changed cell
- find the index number for an array element
- Preventing people from viewing specific worksheets
- Macro just stops in Step Mode
- Install personal dig cert on new machine
- Why is this a incorrect statement? On the surface it appears corre
- Auto size help
- Min and Max Values on Chart
- Select region
- ADO to SQL - smalldatetime problem
- List of VBA Data Types
- run a macro in a protected sheet
- Playing a WAV file in Excel 2002
- magic scissors
- How to: assign a value to a cell without selecting the cell first
- String Parsing : Best Methods : VBA
- Delete command button ?
- Finding values within text and substituting with alternate values.
- VBA loops and subs
- Is there a way to type text upside down in excel cells?
- Deleting duplicate rows
- Nestling of functions
- Combo box won't transmit "blank"
- Multiple Excel Servers
- Input Page
- Call external program in Excel Macro
- How to take chart and paste into Access form
- text to Column and amount from -ve to +ve.
- Macro & VBA
- Copy from text box
- I'm only getting 0
- COM Add-in in VB
- Changing the way it saves
- RollDown ListBox in a macro
- Multicolumn combobox
- Format Painter in VBA?
- Can inserting numbers into a cell display another number elsewhere
- exit event
- Vlookup in VBA
- Cell Value & unchanging Date With Macro run
- Is Alaphabetic
- How Safe is the Excel Password functionality?
- Auto copy and pasting
- How call procedure when worksheet opened?
- Why doesn't 'Range("A65000").Select' work?
- Mod function not working right?
- Mass copy of excel docs
- Sheet tab color
- CommandButton code help
- Need help hiding/unhiding column based on autofilter selection in a different column
- Hiding an empty row?
- Problem getting cell value from range var
- Creating functions
- Formula problems!!
- Using a combobox to select sheets
- Immediate window
- Various errors
- Need more columns in Excel
- Scheduling macros in excel to run auto
- Is there an example of a DB procedure that adds a col of nums
- Spreadsheet updating question
- Copying and skipping (adding) rows
- Variable Problem.
- Select sheet based on userform date input
- Dynamic Control addition and Event response
- Syntax for "and" and "or"
- Can I conditionally delete row in Excel? (if B3=0 delete row B)
- advise pls
- Percentage of subtotal with Pivot
- Right text function
- from ranges tables ???
- Password protected projects (pdfmaker.xla, etc.)
- Formula for the subtotal
- Formating excel
- Anything wrong with Messagebox API?
- Help with Mr. Peterson's Code.. Print serially from a Sheet
- how to expand sort function beyond 3 on excel
- Add menuitems to custom created menu
- export a non defined table as txt or cvs by VBA
- Msgbox not center of screen anymore
- Hats Off to Dave Peterson
- Three userform questions
- updating of worksheet against info from another worksheet
- Changing Cell Backround from Marco
- How to map elements to XML schema by program
- Display Elapsed Time like a Stopwatch
- best method of bulk move of data?
- loop until web page loaded using Netscape Navigator
- Type Mismatch
- Code cleanup help
- Extract last name into a variable using VBA code
- Importing Html Source Part 2
- check for non-blank cells in Microsoft Excel VBA Programming
- Locating cell change event handler
- select adjustment tab in cell format dialog
- Help with Spreadsheet for Handicap
- help w/ generic copy & paste/paste special routine
- sub executed as the form loads
- Importing Web Page Source Code
- Delete Sheet 1
- Delete Sheet
- LastSavedDate
- what is array size limit in VBA?
- Put only date (not time too) in variable from FileDateTime function
- Excel and word macro -
- open print dialog (File ---> Print...)
- Combo Box doesn't display text in linked cell
- Re : Excel Event Worksheet_Change Shuns SpecialCells(xlCellTypeAllValidation)
- BeforeSave
- Table sorting questions
- Import of Multiple Text Files
- Need formula to look up zip codes
- Capturing Row of Selection.Find?
- Sort Combobox List
- Problem in WITH/END WITH code snippet
- Cancel on INPUTBOX macro causes error
- Do Until with Multiple Conditions
- Thanks to LEITH ROSS and to KEN JOHNSON
- Copy column A and column D from all sheets into new worksheet
- Make Drawing Object Unsizeable
- Capturing trendline parameters
- about ontime
- Help with VB code to compare two columns
- Overflow error
- Calling a Macro from module
- New to VBA..need help with automating GETSAVEAS Macro in Excel 2003
- Help with a function
- Is it possible to add more than 2 x-axes to a chart?
- Copy column B and column E from all sheets into new worksheet
- Adding individual cell ref - instead of summation
- Compile problem
- Macro file save as, saving sheet not workbook
- REPOST - Moving Data From Excel into Access
- Get ColorIndex Number for Cell in a Range
- Why Is The Macro Edit Button Disabled?
- Name Range
- userform making wizard, where?
- I need a simple macro but im a noob.
- Picture Hyperlink Path
- Is this possible?
- I want to use C# instead of VBA
- Find name and return records
- variables in footers; how to prompt user for input within macro
- Need coding to DELETE a line on a spreadsheet.
- Worksheet Expiration
- Macro for multiple worksheets
- Application.Run("MacroName", Args)
- Email Attachment Problem
- Split "9:00 - 5:30pm" to "9:00" "17:30"
- Pivot Table sorting
- Working with 2 worksheets
- hide/unhide row macro
- Grouping & Formula's
- UserForm Question
- loop replacement of multiple if-then's
- Can't activate chart
- Get to a new row to add new data
- Context Menu, Paste Special From Selected Range
- Hyperlinks onto buttons
- Use % as variable for user id?
- Any way to capture an Autofilter event?
- Using Autofilter to prompt for criteria
- copy code with spreadsheet
- Not cycling through each sheet
- Network Username
- Formatting Data using a macro
- Importing paradox files into excel
- Find all Pears and then name the range as Pears
- Error processing
- Userform Issue
- User defined error
- Output list based on value in a cell
- Macro to get to VBA Project Password
- InputBox requesting dates between two predefined dates
- Create a Pop up box that prompts for criteria in a macro
- How can I mail merge using filtered data from excel
- userform in an addin
- Converting Text dates into dates
- Form Button - Select Row
- Cut Drawing Objects within a range
- Automate embedding files
- Fill Excel Screen with Form
- Code to control auto filters
- Add 5 blank rows after Word
- Copying TextBox entry from one UserForm to another
- Stopping Code
- ClearContents on 1st sheet from 2nd sheet
- Help with date conversion - yyyymmdd to dd/mm/yyyy
- Retain colours of figures using vlookup between pages
- Proplem copying a Module - Error 50289
- Making only selected PivotFields visible via macro
- Works every second time
- count problem
- keep track of last code line before error
- Password for workbook
- Displaying cell comments.
- How do I sum scattered entries on an Excel worksheet?
- list property of listbox
- validation - error mismatch
- Change ComboBox properties in VBA?
- Atlantic City - Excel User Conference Early Registration is now Open!!
- Menubar Control
- Color of the title bar
- problem with interior.colorindex
- userform - active sheet
- Autofiltering with more than 2 criterias
- Forms - checking fileds have values
- In macros, an instruction that will return the position of the Active Cell
- excel-maple
- free text box on a protected sheet
- re-direct hyperlink event to WebBrowser Object in Excel
- Range
- code for auto filters
- Looping through Labels
- Opening a folder
- How to split and consolidate sheets into new workbooks
- Locked Column
- populate array
- Indexing of Shapes
- How to connect sybase with excel vba?
- problem with import files by excel macro
- problem with import files by excel macro
- Color every second row ?
- How to pass arguments to vlookup in VBA
- User defined event
- Conditional Formatting
- How do I determine OS (98 or XP)?
- Excel Add-in for better graphics
- If/Then/Else formulas in macros
- How to close specific workbook not all active workbooks?
- Taking out the 'Close Button' in the top right hand corner of dialog boxes
- auto fill help needed
- Funny! More offers to select a search engine!
- set dropdown list width in validation
- Autofill to last row
- Help with this code
- Calculating cell references
- Minimising Excel
- How do I lock worksheets so only a couple ranges on each allow inp
- Can I user input to seek out particular files and copy/move them?
- how create library of routines?
- Hyperlink to charts
- How save active workbook w/o knowing name
- Write a macro
- first time class module
- Breaking the External Data Link
- Create new sheet from cell-info and then copy/paste special
- Two criteria in using Combox Boxes
- VB6/Excel: Opening a workbook off a LAN drive
- How Do I Get Custom Captions For MsgBox Buttons
- ComboBox with horizontal range on an Excel USERFORM
- Want a challenge:Finding entry on sheet then adding data???
- syntax for variable
- calling a function in a worksheet from a user form
- PivotTable with No Source Data
- Copy Sheet problem
- how do i obtain a file name from a cell contents and use it to sa.
- Sort beginning one-line BELOW what should be
- Getting Data from closed workbook into userform
- Cell Mapping
- array probs
- getting data from a closed worksheet
- Dim SheetName in chart plot
- How do you change code in the VBE without opening the target workb
- Is there a IsEmptyCell function in VBA?
- Header properties in code
- Strange data type error
- On exclusive open for write
- How to get entries into a list box
- How do I create a macro to switch sheets
- Opening Workbooks / Filling Array
- Sheets("Sheet1").Move After:=Sheets(2)
- how do u use a cell value for the save to filename
- Application OnTime...need some help to schedule.
- How to advance one column to right?
- Opening Excel In IE
- Search & replace in VBE on other workbooks & different directorie
- Copy a cell content into a TextBox
- Cancel "Save Workbook" popup
- Import data from multiple tables
- Vlookup in VBA. How can I?
- How do I do mail merge using filtered data
- My Excel drop-down list eliminates from list options chosen. Help
- Removing duplicates from multiple arrays
- Commandbutton picture problem
- How to change cell color with reference to a formula?
- Compile Error: Argument not optional
- Picture Hyerlink Path
- Format excel data
- Bouton inaccessible dans Excel 2002
- Open files in order
- Turn Off Alert Before Overwriting Message Box
- Series.Values vs Chart.SetSourceData
- union array
- PDF to Excel
- Excel VBA - Inserting associated values in a report Please Help :)
- VB Code Source
- Running Macro's after Refreshing data
- Create or change color of a (line with arrow head) with a Macro en
- ChangeLink Command Not Working
- Macro to evaluate a cell and replace one part of the formula
- Hiding Columns
- For Each loop
- Input Box Related Question
- RE: Input Box Related Question
- SumProduct If?
- Input Box Related Question
- Null Operator
- Workbook disappeared
- Paste formula
- Problems calling macros from "ThisWorkbook"
- Textbox Format
- Unprotect shared worksheet
- Zoom and Scroll Form
- Unselecting a Reference
- How to remove the ' charachter
- Open mdb file from another computer
- Colour active row but allow copy / paste
- Batch Files
- Match, Sort unique list
- Controlling Chart Views
- MsQuery Refresh Message
- Commandbar on thisworkbook only
- Problem with copying a button in VB
- #If #else #endif
- Why wont my Pivot table update?
- How to create a macro for this?
- How to share variable values between 2 Workbooks ?
- Timer Code
- Refresh Pivot Table: Do you want to replace the destination cells
- Question about range values with Set =
- Adapt code to show filter
- Extracting information from more than 1 text files
- Changing pivot table Page
- UDFs in worksheets with external data sources
- Aggregate function
- changing the properties of an excel file
- Create macro to paste rows of text cells to lower end of other row
- Help With Insert Row Macro
- Help
- out of range error message
- Collection Look Up - By Key in an Excel VBA App.
- Creating charts from a .dat file with vba.
- Writing Excel Macros in VB.NET/C#
- Pivot Range
- VB formula referencing other worksheet
- Security questions help please
- e-mail help
- Questions related to Online Quiz
- Calling an Excel function from a VBA macro
- How to generate dates for a month?
- Find with a variable
- Use Macro to Run External Program
- Issue with Excel Add-in for Analysis Services
- Compress column
- Conditional formatting based on not null value
- checking for a running app
- how to know be button in activecell
- VBA equivalent of Javascript continue
- Moving Data From Excel into Access
- Extracting records from an excel list
- Risk Issues register
- importing Word table data into Excel - solutions for automation
- Run macro after save
- Need to select/report all rows based on content
- Macro Enable/Disable
- Question about working with range array
- average of the range
- Returning an integer from a Function
- Ignore workbook_open() when opening workbook next time
- Having trouble with a IsNull function
- How do I switch openoffice back to excel
- Subquery after Left Join
- Undo button??
- To show the whole text in a tooltip text
- select specific records
- How to Disable drag and drop of Pictures from Excel
- Deleting Columns
- Suppress "Disable/Enable Macros" and Query Refresh dialog on open
- I dentifying cell and ranges using n as in For n =1 to 600
- User Forms - Command Button defines value to be used later
- ChangeEvent
- Set UserForm's HelpContextID with Designer
- Excel rounding bug for input to Variant data type
- password popup unneeded
- VBA for XL97
- range with L C
- custom menu 4+ levels deep
- VBA Project Properties
- ActiveWorkbook.SaveAs FileName;= 'sequential
- Unable to record complicated formula in macro
- How to pre-select/highlite contents in input window.
- Yet another Listbox question...
- Insert Picture Name Assignment in Macro
- range class error
- Excel formula to return a blank cell
- Pasting in a range
- Open file macro
- Subtotal function in VBA
- macro to copy range data from another workbook
- Inputting data to next blank cell
- Excel Format-Cells-Number for Zip Codes
- HELP!!! Advanced Filtering to another Worksheet
- Linking Excel template and spreadsheet in separate workbooks
- Insert Sheet
- Cell description/comment/tool tip?
- Work in Other Software
- How to consolidate workbooks automatically from multiple emails?
- Excel sets calculation to Manual automatically
- VBA Print Code Is Too Small
- How to create blank spaces
- how can I cancel a macro in excel?
- Remove/suppress Auto_Open macro
- How To Use Debug
- update Link from protected wb OR prompt for protecting a worksheet
- Disabeling key
- Changing text to number format using type casting
- Function not dividing properly. Please Help!
- How do I automatically accept a solver solution in a macro?
- Obtain imported file modified date
- Program to replace information .... ?
- Error Trapping Question
- Should Enum create a selection Box?
- excel
- excel
- Groups to Tabs
- How do I use absolute references in macros?
- Please Explain Two Lines of Code
- Variable value not populating
- How to check workbook is already opened before passing the workbook obj to a subroutine in Word
- procedure continuously being called
- Characters before the space
- error convert to number macro
- Hide/Unhide Rows
- Save an excel file in vbscript without user prompt
- what is the difference between embedded chart and chart-in-a-sheet
- How to get a reverse filter list?
- Autofill problems
- Checking entire cloumn for values
- Comparing cells in workbooks
- HELP! saving as xls in current folder
- GoalSeek, values to formats? help!
- writing to next row in sheet
- Print to pdf and save without prompts
- Problem with USEDRANGE.ROWS.COUNT reporting one row too many
- how to change values to formula in VBA to carry out goal seek?
- Extract Time
- INNER JOIN problem
- Object Movement
- Renaming folders and changing links accordingly
- Application Defined Error
- open dialog box
- Copying data at specific positions
- Determine if column is within range of columns
- How do I get a number to increase by 1 when opening excel
- Problem in making Excel.WorkBook from VB.NET
- range name as rowsource of listbox?
- Unique Idenification Number
- csv to xls - data format
- How to find a particular work and give the comment in a different cell
- Save embedded doc to file
- how to lookup one source with alot of table array?
- creating a log sheet
- Calculating Time Elapsed in Excel
- Absolute hyperlink
- Saving file with date on it
- Invoking macro when a tab is selected
- Storing workbook name
- urgent please - on checkboxes
- Supress display of multiple steps in Macro
- Find a cell with date in it
- macro to remove worksheet-level passwords
- Running times
- Application.Dialogs(xlDialogWorkbookCopy)
- turning a negative into a positive
- Application.Caller syntax for worksheets?
- Using Hiden worksheets through a hyperlink.
- ListBox Questions
- VBA - Translate VBA Line
- Using Date() function then adding 1 day to it.
- Code cleanup
- How do you change the Worksheet Menu Bar "icon"?
- Does querytables supprt https (MAC and/or PC)
- How would I do this programming problem?
- Naming worksheets
- Open file with relative reference
- Cells Data Validation
- Last cell
- Bringing Comments with cell contents when using AutoFilter
- Representation of optional parameters in Function arguments window
- Automatically hiding rows with specific values
- Matrices in VBA / Excel
- Range.Find abend on XP/Excel 2003
- For index = 2 To Source.Rows.Count
- auto load personal command bar
- Dropdown
- Macro
- AutoFilter method of Range class failed
- Need help unprotecting workbook before importing
- Color Range of Cells
- auto reminder
- combining 2 codes
- How can I move and entire row upon cell completion?
- Dynamic SQL Query
- Command buttons freezing up - help!
- error "The macros in this project are disabled"
- Sending data from a cell to a blank table
- Protecting my project
- Continuation of message re: Range Names
- Deleting variable web query name
- ThisWorkbook.Path not working...
- pivot table - works manually not by macro
- Execute Macros through Hyperlinks.
- How Do You Take Data Off A Sheet and Store It In An Array
- Conditional Formatting
- Conditional Formatting
- email
- ideas to case
- Control Toolbox does not appear when trying to design a Userform!
- Open recently made .csv in notepad
- Scale of Graph in Excel97
- Help on Macros
- Automatically Save
- Change formula file reference by changing value in cell
- Auto macro in Excel help
- Re-protect if originally protected, leave unprotected if not?
- Filters and Macros
- Send Excel attachment, but wait till Outlook closes
- Specifying criteria in Excel for Access Query
- Range Find got Subscript out of range
- Export UserForm Image for use in Microsoft Word
- Reorganising data - macro needed?
- Help Please!
- Detecting the space character
- Date format problem
- Modify Macro To LookUp 2 Tables
- Array, multiple sheets
- Comparing data on two tabs
- Why is excel solver saying that there is not a feasible solution?
- Coverting a txt file to multiple Workbooks
- Cell generation from user input question.
- Keep VBA window hidden
- Nestling functions
- Creating Excel Object in C#
- text overlay on image
- How to copy cells excel data and paste them under MS Word bookmark
- Pasting Error
- How do you delete an exported file from a directory
- simple macro gives error .. help needed
- Counting Comments
- How to make a module library.
- Saving, Opening Spreadsheets In Array
- How stop display of worksheets during macro
- set up toggle button to set print area
- selection.find help!
- Drawing borders with Macro
- Defining worksheet specific range names
- Define Range Name with variable row value
- Calling other programs in Macro
- File not opening
- my sheet is locked and protected, i want to insert row with autofo
- Calculate data from Access and return to Access
- can I program currency conversion in real time?
- Close userform after 2 seconds
- Automation Error
- sum in random files.xls how?
- Run-Time Error
- CommandButton objects move in worksheet
- Saving Worksheet from Workbook with Names from Cell Values
- run time error
- Change the colour of a row depending on the contents of a date cell
- Invalid internet address
- for figure in Excel
- VBA coding
- Copy paste code fails
- covert only cell references in selected cells into value leaving the existingcell formula
- Excel Color Palette problem ...
- copy just subtotals ?
- easy macro?
- Identifying the type of a Worksheet_Change
- Sending an email on workbook save
- Promptbox value to go in the next empty cell
- A curious question
- Copy and Paste Macro
- HELP: Dir() time-out woes :( .....
- Urgent help neede filter data in notepad to excel
- Check for repeated input
- Email to multiple persons
- Compile error automation error
- Block inser or delete rows
- compile error automation error
- VBA Sum
- Please help.
- selecting random cells
- Drop Down Form Number List
- Macros for copying the data
- Change case on Entry
- Module Options
- defining number range in textbox
- highlighting part of string?
- looking for Excel programming help for project
- Macro working on my pc but no one else's
- VBA Code
- SUM function help
- Selecting entire rows contents
- Macro
- Clicking Taskbar Icon will start macro
- Move Around Excel While VBA code is running.
- VBA
- Problems with Protect Method
- Fast way to hide all pivot items in VBA?
- Method 'Range' of object '_Global' failed
- Manipulate Controls added at runtime
- Data Extraction from a cell
- User form Object corruption
- Shared Workbook Saving Problem
- MS SQL and Excel
- Need help importing data to multple worksheets.
- Import Text File w/ VBA
- Cancel button to cancel the whole macro
- Retrieving Data from a worksheet to auto fill a user form
- Preventing FALSE.xls when automating SaveAs
- Grouping numbers, disregarding the minimum
- Searching for records that end in a specific character
- Variable not working as email address
- Trouble with Visual Fox Pro Database
- Macro enters formula but it won't calculate!
- Hvordan legger jeg inn slik at noen fast betsemte ord kommer med f
- .Name case sensitive
- Compare two sheets and perform action routine
- Number of files in a folder
- how do insert rows and maintain the hyperlink in Excel?
- Can PIVOT tables do this?
- Hold down f8
- macro -find all occurences of a word-change color of cell of all
- Better way to apply formula to multiple cells?
- Open a webpage using Javascript in Excel
- Remembering Worksheet View after Event Code
- Re: Paste by rows and blank cell problems
- E-mailing from Excel 2003 problem
- TextBox value
- need some editing of a template macro.
- userform error
- howto send host fonts to adobe pdf printer
- unexpected result from inputbox
- Drawn Object Woes
- Track changes
- AutoFill Loop
- How do I set up a vacation report using hours alloted based on hir
- Get the reference from a referenced cell
- Range selection
- cannot empty clipboard
- True/False : 1/0
- Excel User form with 4 Combo Boxes
- Simple macro problem
- Indirect Referencing in a Macro
- Create arcTan function
- Close workbook problem
- Need script for filtering data
- Autocomplete
- Embedded a .gif animation into a form
- Adding Range Names
- using saveas twice will be error,savecopyas don't use also,why?
- Is there a "Find If" type command?
- Length of worksheet name
- deactivate macro or LostFocus
- Select certain data from a Pivot and copy this into Powerpoint
- Consolidating Several Excel Files
- Find and Copy
- is there a currency conversion function?
- Create multiple copies of rows based on a cell value
- Help with code
- pivot table build using excel macro
- Difference in Values for Price function in Excel
- Auto fill form with data from worksheet
- Prevent error messagebox when refresing querytable from the web fails
- report output format
- Colour Question
- Copying cells...
- Until end of array ?
- Adding column title
- Split code in more than one page ?
- display rows that meet two conditions
- Reference dialog box
- How to open or view VBA project only
- amend this routine to use something other than Application.FileSearch
- close excel application
- Insert Row Macro Help
- how to make the formula
- Hide/Unhide Sheets
- Compile XLS sheet into EXE
- String compare doesn't compare?
- Drawing Problem
- VBA If Statements
- Image Click Invokes Picture Toolbar
- add a new row once list selected
- Trim pace not necceesary
- Unload multiple forms
- Copy rows from one file to another file
- Links from other files
- Scroll to top of page code
- VBA VLookup
- protecting macro code
- Reference to solver problem
- Reference to solver problem
- nested loops
- set up a repeating header or footer to entire workbook
- CommandButtons
- Resizing Userform to screen size
- select and print
- Identifying complex duplicates
- Accessing rows after AutoFilter
- This should be simple?
- macro slows down
- Debugs with Copy / Paste
- Copy from another workbook
- Really Slow Running of Macro
- Macro For Deleting Cells Containing A Number
- Run Time Error 9???
- Random Number comparison
- What does Ctrl+Shift+Enter do? How does it differ from Enter?
- Realtime Data Update Sorting
- How to? Copy from one location to multiple locations (easy)?
- Get RGB color ?
- How to update values on cells in visible range only
- Updating Querytables and Pivottables
- Desperation is Setting in - Date Formats! :-(
- Why does SUM not compute, even if the cells display numeric values
- Find textboxes on a form ?
- VBA
- Macro button not appearing when workbook opened?
- newbie.... need some code... I HOPE!
- are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "?
- Modifying Data inside an array
- Worksheet Focus
- VBA Query again Informix database
- Loading Pictures in Image box
- query sql database
- query sql database
- query sql database
- Drop down list - display text vs actual value?
- VSTO 2003 Excel Command Bars
- Run a Macro via a Scheduled Time
- how to set 'security level' to low in auto like vba
- A challenge for the Excel Experts among us (ActiveX Control & Add-ins)
- What's the best solution to accomplish this?
- How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks?
- Autofill with changes
- resize and copy
- My problem with char(30)
- Clear array ?
- Compare workbooks
- Any way to do this faster?
- Respond at a specific time
- Find files and sum a value inside sheets (VBA)
- Dim an Array with a variable
- Web Query
- Set print area problem
- Type Error in For Each Worksheet Loop
- Date in data imported from MYOB to Excel 2003
- varying colors on a graph
- A Userform goodie - updating records
- Workbook_SheetChange
- VBA Help, cant figure out why it dosn't work.
- Prevent user from overwriting file
- VBA newbie question
- how to speed Find/Replace in Excel(Using VB)
- Creating a folder
- MatchRequired - how to trap the error when a matching entry is not input
- Copy and Pasting into new Sheets
- Require certain password for sheet1 to save
- msg box to clear a sheet
- Get Worksheet Name
- finding ROW without selecting worksheet
- worksheet event macros
- Store hyperlink, when filename may have # in the name?
- Perform Row Function Using Macro
- Copy cell properties from master when user enters a new line.
- Excel is multi threaded program? thanks
- Combining find with clearcontents on multiple columns
- SQL scripts and ODBC
- Finding next empty empty cell in a range of columns
- Need help writing a filtering routine
- class/struct functionality in VBA?
- validation
- Tweaking a Macro to Count Words
- Module vs Class Module
- Loading and changing a photo
- Validate all cell values against it's list prior to saving the she
- Grouping into a Tab
- Treeview expanding when saving a workbook
- Can I remove prefix apostrophe
- rename current file save and delete original
- Finding next available empty cell in a row
- Hidden Character Find Macro Help
- Need macro to generate list
- Sort an array
- duplicating cells in diffrent sheets
- Closing Code
- Slightly long winded transposition
- MultiPage
- Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
- Won't close w/routine
- prevent UDF from executing
- Disable a Specific Message Box
- BeforePrint macro difficulties
- Deleting rows before importing
- MS query return multiple columns in Excel
- Speech Recognition in an Excel Macro
- Having a mcro prompt me for manual input in cell
- change event
- Encryption
- macro help please
- Macro problem
- Delete WB
- How to use VBA to update a SQL Server Table from a Spreadsheet
- Setting Public Variables Error
- Looping through rows and shifting certain contents
- Option Button
- Locking cells
- Too few parameters
- Determine begin month date from month end date.
- Adding controls to each page in a multipage form
- A tricky macro -
- populating a dropdown based on choice from a previous dropdown
- protect/unprotect all sheets
- Populate the Concatenate function using VBA
- Excel Scheduling
- Hide and/or Unhide Worksheets
- Macro Drop Down Box
- Easier Way to do it?
- Project password
- is Excel written with multiple threads?
- Help with multiple "IF" functions
- Override built-in commands
- Indirect reference
- change error message when no more for "find" in macro to find
- Coping a Worksheet - but Getting an Error
- Superscript Button
- Convert Excel. xls to .exe
- Hiding Zeros
- Auto Row Height
- ActiveCell = " < "
- File Open Check
- multi page object from excel vba toolkit
- command button to move user to specific spot on different sheet
- ifcount evaluates always false
- UserForm problem
- local security policies
- Writing update date and time in a cell on inputs
- Require Cell Entry based on condition
- Reference
- Passing a function from VB with text strings in quotation marks
- Get two Values from closed Workbooks
- storing of VBA code
- control button used to clear a sheet
- Checking to see a sheet of the same name exsists
- Protecting multiple worksheets
- Is this really possible?
- organization chart
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.