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 |
- Can I prevent a user from running a macro?
- afterupdate event in Excel
- Conditional Format to highlight differances between to sets of data
- Any way to add hex numbers?
- For each, Next - 4 worksheets
- Pivot table
- restore sheet
- Macro to select a cell in a table from a reference in a different
- Copy Up To Top 10 To New Worksheet
- Graphics question
- How do I resolve recordset overflow?
- Can I add data to a pivot cache?
- VBA for Virtual Earth
- Last saved by
- Sales Schedule
- raw of code..
- need more than just 3 conditional formatting.
- Create custom wildcard for searches?
- automatic unique value extract
- trying to make a simple search.....
- worksheets scrolling
- Can't change pivotfilter value1 parameter in code
- Get errors when updating PivotFilters
- Date formats change (code included)
- transitions in ms excel
- Delete data Help!!
- closing a workbook with a macro
- Save user entered value in hidden lookup table.
- Test for File Creation Date
- Processing groupbox values
- How do I select a range to merge cells?
- Recongnizing #N/A as cell contents
- close workbook event
- Kill all files in Folder, If folder exists
- Copy row from one workbook to another
- serial port
- Run a macro from a vbyesno Msg box response
- Compile error [Chr(13)]
- colour palette reset
- Disable links to other workbooks
- Hiding option buttons
- Lost from memory
- HOW DO I DETERMINE AN EXCEL FILE CONTAIN MACROS OR NOT WITHOUT OP.
- for next loops in visual basic excel
- Second Sunday in the month of May?
- Top 5 most recurrent values in range.
- Delete Column having specific word/value
- Enable / Disable Buttons
- Reinstall Custom toolbars
- Inputbox & “Processing…” window
- Open file for output
- XL2007 .CodeName bug when copying sheet
- Tracking training by percentage
- conditional format - put inside a for/next loop
- Setting a cell background color
- Programming Validation
- Some Error on e-mail
- Include "00"
- Converting CtrlShiftSpacebar to VBA code
- Creating a Custom Worksheet Object
- workbook code window
- Instruct to start in Row 5
- Insert data into SQL Server db - find out the record number
- For Loop
- Run Macro based on cell change
- Trigger Macro based on single Cell change
- Trim Entire Column
- Textbox not filling from listbox
- excel macro
- Excel 2007 ang "Group row" option
- truncate text in each cell in column
- MsgBox responce If statment
- Run Macro at specified time
- HELP: Performing multiple cell changes in a range - converting text to numeric
- print embedded multiple page OLE objects
- VBA searching through range and pasting value if no match is found
- Importing stored procedures into Excel with parameters
- UDFs and Conditional Formatting?
- Excel 07 vs. 03 "listrows" reference <subscript out of range>
- Generate data with all combinations
- Sending PDF with Outlook
- LOOKUP, MATCH MORE MATCHES IN TWO COLUMN
- Select only Text duplication
- Can Add-in determine if macros enabled in another workbook?
- Calling a Sub in Personal.xls
- XL2007: Copying worksheets between workbooks
- Split LastName, First Name column into 2 seperate columns
- How to move data from many spreadsheets to one
- Help with Correct Call for Ron de Bruin's "RDB_Last" to Find Last Row in a Column
- What code for repeatedly copy, paste values ??
- Changing properties of a file with VBA
- How to get a permanent Range address?
- Out of control Active Cell Indicator
- ChartWizard difference between Excel 2003 and 2007
- How to list Workbooks associated with VBA Code.
- Textboxes not populating from listbox
- Getting a "Read-Only" error
- wait msgbox for 3 seconds only
- Random Cell Value Display?
- Trigger VB code on user selection from Page field in Pivottable
- Email Workbook - Outlook object model (attachment) - runtime error
- auto close in Excel 2007
- change pivot filter through code
- Edit Cell with "/2"
- function to modify other cells
- 2003 vs 2007 Macros
- double sound alert for on-line stream
- Class module Question
- Problem with MUI and Excel Add-in
- Copy two sheets into new files and save to multiple locations
- how do I pass myfunction(A2:A4) instead of myfunction("A2:A4")
- Headers and Footers by VBA?
- Sorting a range with duplicate values
- Which Dialog Button? (XL95 in XL2007!)
- ADO Connections
- OR
- prevent doubleclick for command button
- How to Activate and Dropdown a Combo Box
- sumproduct problem
- macro
- Loop within a loop
- Link an IF to a Vlooup
- Formula Array - Syntax Error
- Determining if Cell has Formula
- Deletion of Data across multiple sheet
- execute a macro from a dialog box on enter
- Problems with mouse in Excel Automation from VC++ 6.0.
- strange behaviour
- Transfer files & change file attributes with VBA ?
- Workbook_BeforeSave not working.
- Ranges vs cells with VBA
- draging formula
- script help!
- IF function to get a (specific) name from a Vlookup and convert va
- PERSONAL CRASH
- Automatic Unique Values
- Running a macros every Monday, Wednesday, and Friday
- Cell specific code
- Validation list problem
- Define the Range of a drop-down list
- Link an IF formula with a cell containing a Vlookup formula
- Combo and List box combination
- Counting unique formats in a workbook
- switching between workbooks
- userform duplicate control not working in my code. Thank you
- ShowMe function works fine except I need the offset to adjustdepending on column
- Connecting Excel to Access Using Late Binding
- Counting backwards through the File System Object files collection
- setting ranges and vlookup in custom functions
- Flashing Cell for a number range
- Calculating Staffing on a Schedule
- Contiguous Ranges and 255 Char Limit Constraint
- array formula doesnt work from row 32737
- Text box macro button...need it to remain stationary.
- Listbox Change events triggering when i "Save As"
- Format Paste from nonmerged cell to merged cell
- Cells Within Range Failure?
- Improvements to code
- Auto Open + Disable on Final Product
- Populate an input box in a macro
- Open Access DB in Excel 2007
- Duplicate Group Names
- this newsgroup on easynews
- Closing multiple workbooks?
- Excel macros in XL2k Pro vs Std
- Use loop to filter, copy/paste to new sheet; run through entire li
- Combining Variable Sized Ranges
- Multipage default open
- search box
- Changing tab order of locked worksheet cells
- I want 'Enter' to be a line break in a text-box
- Sort in Office 2007
- Reading Comm Port in Excel
- Change cell colour to red
- How to: If autofilter is "all" then, else...
- changing a color based on another color change
- vlookup function
- Getting r/t 13 - Type Mismatch on this line - Why?
- Count all "xlsx" fromat files in a Folder
- Doughnut chart with VBA
- COM Controls in Excel
- Next blank cell
- Remove Middle Initial
- Delete row/s with the same elements as the above row
- Deleting a sheet with VBA
- VBA ".Clear" Error
- insert table into specific location
- Help with converting code - import > 65536 from Access
- Find, Copy and Paste
- Please Help on Object Library Invalid or contains....
- Sumproduct VBA
- comparing 2 worsheets using a macro
- Another Simple GoalSeek question ??
- What do I need to do o = New Excel.Application
- Code acting weird with sheets with collapsed groups
- Calendar Control Linked Cell
- linking pivot table selections
- How do I create a Reset Button on a form created in Excel
- Two problems inserting a formula
- Override a built-in command with a macro
- AutoSize a cell comment
- Font in MsgBox?
- count number of times a particular letter appears in a cell
- Excel Security Update 2003 (KB955466)
- Totals An Easier Way??
- Number Stored as Text Issue
- For each chart loop not working
- Excel code
- Translate to code
- Using Offset on two seperate worksheet
- Active Workbork Issue
- Delete row with the same elements as the one above
- Working with Linked files
- Calendar control (view/layout problem)
- If A1= yes then calculate index
- Delete Entire Row for duplicate values in selected column
- How to Select Successive Groups of Individuals for Trendlines
- Finding the last used column
- Using Query to return data from SQL database
- RUNTIME ERROR 1004
- Macro to select only cells containing values within named range
- change pivot table in code
- New VAT Rate
- how to wright this formula in VBA code
- Assign Shortcuts
- Importing .csv with #2000-04-06 10:15:00# date format field
- How to expand or stres row summaries back to row details?
- How do I add properties to add-in ?
- Marco that will run if the condition met 2
- Excel / SQLite
- Finding ways to identify last row of every printed page
- Open file dialog box works in XL2000 but not in XL2003
- Continue running macro until last line of data.
- Adding a right-click context menu to Excel VBA TextBoxes
- Macro to select data Validation List Item
- Conditional find and copy to different worksheet.
- Changing font color based on type cell it is. How to do it?
- code stops working after X rows.
- Using Ron's Sub Copy_to_Workbooks
- Use CASE?
- Alphabetical sort but includes the expanded section when it rearra
- Changing hour and minutes to percentage of hours
- Change Value of Cell in Printed Title - Print Preview Event?
- What is wrong with this?
- List out the "Find All" results list?
- Copy and Paste + erasing date
- a few adjustment for a do-loop escape
- sumproduct in VBA
- Create Object for MS Mail
- time formula
- to many e-mails
- Copy Row 2 from Sheet1 & Paste to Row 10 Sheet2
- Status Bar Message
- Text box last entry
- Start my Application in its OWN instance?
- Autosize
- copy adjacent cells also and put totals at the end (for copied cel
- How to enter a non-standard format hyperlink
- For every empty cell in a column, copy the value from the above ce
- conditional formating
- Copy data from new file in a folder
- Date value
- Change a pivot field based on another pivot field
- Run time error 53, cannot find file
- Finding/Moving Columns within Macro
- Assigned macro change
- Vlookup - Multiple Sheet HELP PLEASEEEEEEEEE
- Functions
- Reapply filter
- Filtering Automatically
- my incomplete macro to fill in 8000 rows - pls help
- Run code conditional on sheet visibility
- Close form when I press enter
- Change MS Access query from Excel
- User input - string on userform
- batch update excel with add-in
- How to change MS Query via VBA
- Sumif
- Following a web query with a macro
- Color cell font text based on cell type? How do it.
- Splitting a row of email addresses
- Match, then Look Left 4 Columns, then Loop to End of Range
- Copy picture from http to local drive?
- Error Message: "Can't Execute Code in Break Mode"
- Picture in spreadsheet to picture in userform?
- Multiple workbooks - NEED HELP
- ASP.NET 2.0 in Visual Basic Language
- error with chart object
- Match six digits and copy specified row
- macro to keep chart dual axis format
- Data filling question
- Excel Application Examples?
- How to order numbers
- Dynamic Userforms,
- looping through txt files and pasting into a excel worksheet
- Conflict Between Two Add-Ins
- List of open workbooks and their User Names from Folder X
- Formatting borders
- running change events to macros
- Print Access reports from Excel
- Naming Check Boxes
- Run a procedure in all the sheets of the workbook.
- Select item in dropdown using VBA
- Hiding columns with shaded headers
- SelectionChange Question
- sort alphabetically a combo box list
- Correction Needed in Macro
- Re: Workbook has [Group] at the end of teh file name when opened
- Special sum of texts
- Clearing Validations from many worksheets
- Re: sytokromi-c wikipediassa
- Marcro
- excel does not opens on IIS
- Probklem with code, when merged cells
- Multiple if statements in one cell
- Question for the Probability Mathematicians
- Automatic Alphabetical Sort
- Simple Macro to "Lookup -> Repeat"
- Matchv values on two different excel workbooks
- Input box with dropdown list of all sheets
- Office Assistant 2007 ?
- Re : Excel AutoFilter Drop-Down Window
- Download & Upload to Online Sheet
- Use a VBA function to return a factor
- Runtime 1004 Error Help Request
- Reading from a protected range in Excel
- Hyperlink syntax??
- Creating a macro
- Autofilter
- simple code
- Parsing a string
- Remove an obsolete worksheet from an addin.
- Macro to grab data from a chart
- Weibull function return an error
- Deleting Rows
- Taking Flat Data in Excel and Making it Relational in Word
- Excel Macro Help
- Problem loading an array
- Macro to Break into Seperate Columns
- Help Modifying Ron de Bruin's MergeAllWorkbooks Subroutine
- Range syntax help for a VBA newbie
- Find and Replace
- Cell coloring giving me fits
- Workbook_Open command fails and blows up all cell formulas
- Excel automation failure
- Date Computation
- Data Search
- 2 dimensional array
- VBA Help
- Print Area Range Selection
- Nested Do While Loops
- Replacing code
- filedialog in conjunction with printing to a text file
- Chart Type - numeric values
- Problem with list not showing after a macro running
- Can warning messages be suppressed in Excel?
- Adding values to a range
- Receive data from barcode reader in VBA
- Folder size
- Run-time error 9
- Why does the following custom function always return a "value" err
- Resetting Keyboard Shortcuts
- Need to save a range as a text file
- skip rows depending value of a particular cell in that row
- GammaDist function error in error
- Help with deleting rows
- Get Data from One sheet to Other
- Launch IE with Table
- Leading zeros in IP address?
- Method 'Height' of object 'ChartObject' failed
- Focus problem??
- custom function closed workbooks
- Finding Chart Series Problem
- Question on using Ron de Bruin's Excel menu sample code
- Open a new file and format the tool bar.
- Hide rows that doesn't match cell
- Unable to access complex arithmetic functions in VBA for Excel 200
- Assing a Name to a Range
- multi Loop efficiency
- Msgbox Close with vba
- Combo Box font Change
- Reading the characters in a cell
- I need help with VB code
- vba run-time error between 2 difference releases of excel/access 2
- how to display 2 lines depending on one cell
- Formula with MID() not working
- Condensing working code
- Autofit / Remove formats VBA Code
- Copying and Pasting a picture from one sheet to another
- Object required error
- Macro to remove rows
- 2 columns processing
- Extracting the Time from a Date/Time Stamp
- Replacing via macro
- Reset a User Defined Types Values
- Macro that opens an xls file then saves it with another name
- Find the minimum and maximum date in a list
- Problem with Lifeboat Hang error and DDE
- Macro for removing error values in cells.
- What reference is needed to select the progress bar control?
- Data Validation - Do not want to allow pasting into the cell
- pick calendar date and day
- Inserting cells using VBA
- Formula in Excel to get additional column values associated with M
- Deleting Duplicate with a Msg box which displays no of duplicates
- How to save current filter of Table(ListObject) and to apply it la
- Using VB, remove a certain section from ThisWorkbook
- Lotus Notes CreateObject
- Turn off read only attribute on shortcut
- RE: Formatting a Chart Based On What Values Are Displayed
- RE: Formatting a Chart Based On What Values Are Displayed
- ignore error
- Duplicate Detection with Message Box
- Vlookup in a Macro
- Access command from Excel
- xlValue et al.
- Incorrect name on pivot table
- Automatic formula entry, file save and cell blanking
- Pasting Selections from Multiple Sheets along with their Sheet's Name
- Poor Performance on LARGE Excel workbooks containing formulas
- fill weekdays with date
- Hyperlinking to a hidden workbook
- sumifs to other workbooks
- RE: Copy data from range
- A Question on Ron de Bruin's "Copy a range from closed workbook" function
- Time issue
- Select range
- How can you change cell attributes in a function??
- convert US date format to Excel readable
- Programmatically modifying code using VBE in a protected project
- drop first row in range and return a new range object
- Custom NumberFormat - international version
- dropdown box item to display a message
- How to set LastCell?
- Events for CheckBox inside Excel using ExcelAddIn project
- Last cell in column
- Inserting Dashes
- Any body to crack it ?: Print Week Category based on range for mon
- Marco that will run if the condition met
- Labell Height
- How to calculate time difference in hrs
- Print specific ranges in several sheets
- last row in column
- Hello:
- range.createnames method
- how can i count multiple variables in multiple columns?
- macro- keep value in cell and add value for adjacent cell
- Date selector combobox
- Enlcosing code inside if- then no longer works
- Match 1 cell of record and Transpose 2 cells to another sheet.
- delete the non blank rows
- Edit cell value
- Function to retrieve embedded URL link?
- Why this "error 9"?
- code to automatically compress photos
- Edit Column Letters
- Sorry for this: How do I stop receiving all the emails about newposts?
- VBA Code for Custom Date Filter
- Resize problem
- Constant execution of ListBox.Click
- How to generate on a chart or spreadsheet a date line marker
- How to control if a cell references versus list box or another cel
- trying to create a form that will stop you if you leave a cell bla
- Filter Records based on the value selected from a drop-down list b
- Problems with repeated call of userform
- VBA Expected end of statement ERROR
- Help with macro
- Formula... like text
- Dates between two sheets...
- Macro to take latest data
- Excel not recognizing module.
- Re: Print all Sheet2 of all Workbooks in Folder
- Execute code on a range of cells, then move down and do again?
- Help Modifying Macro - Merge multiple sheets based on a condition
- Re: Macro Adjust Based on Dataset?
- Adding MAcros using C#
- Sheet Protection Properties lost
- Macro Adjust Based on Dataset?
- This clever code ain't doing nothin, why?
- Trying to create err msg if cell is left blank
- slow (and wrong?) For...Next loop
- Excel/Access Question
- How to write Excel GUIs with VS2008 Express
- Excel selects multiple cells with mouse click - how to stop this
- comparing rows in a range with another row in a nother range
- Excel Matrix problem
- XL2002 - ActiveWindow.Zoom = TRUE (to selection)
- How to bind events for formsControls inside Excel
- Print all Sheet2 of all Workbooks in Folder
- sending excel worksheets by email
- After Running AddIn - continued
- After running AddIn, application needs to be re-drawn
- Open file with custom button
- Want delete rows if A have value and O not
- Zoom problem with shapes in Excel 2007
- Copying Chuns - A part of the whole Field - from Access to Excel
- Use macro to delete worksheet without specific name Eg:Sheet 1
- Code pause when disconnecting from Terminal Services.
- Opening word from within xls
- FollowHyperlink causes error
- delete the non blank rows depending on Column
- Print Week Category based on range for month
- Password on forms
- combobox list range
- Problem using =HYPERLINK() formula rather than literal hyperlinks incells
- Pivot Table help
- Excel 2007: macros disabled on new Vista machine
- Match Entry
- approve email macro
- Data Validation List
- Form Location on Screen
- UserControl
- SeriesCollection object
- comibantion of various functions
- Close Projects in Project Explorer
- Question on Custom Views
- modify existing macro
- Turn off Autofilter but leave rows hidden.
- User Type vs. Variable
- Issue with my Loop Function
- Delete rows based on date input
- Name disappears after Application.Run
- How can I cut+paste formulas+formats?
- Tool bar to follow spreadsheet
- Custom Format use with MATCH function
- Command Button or Macro that will email a spreasheet
- How do I create a multiple selection list box in Excel with VBA?
- How do I create a multi selection list box with VBA code?
- Count Unique Records in Filtered List
- Clearing an integer variable
- Code to Minimize the riboon
- Visual Studio and Excel
- refer to active window when more than one window open for a file
- VBA Userform - Editing Controls (Similar to Dataform) (Excel 97)
- Search and Replace via VBA
- Question on copying a range
- Remove All White Space
- Converting number into words
- Excel Sort changing 10 to 1
- ActiveWorkbook.RefreshAll waiting time
- Reading more than 255 chars from Excel.
- Problem accessing Sub routines in Addin modules
- Use of UCase
- Start a macro when a vlooup formula shows a new value
- referring to columns by number
- Modify a remote cell
- Dictator Apps and Excel 2007
- Run-time error '-2147352571'
- Create a macro which populates a powerpoint slide from excel tabel
- Subscript out of range
- Macros from C#
- Copy and paste data using macro
- Build Array
- Find Yellow error code
- Problem with For Each loop
- XmlMaps "java_Map40"
- Extracting file from a zip file
- Clear frame color
- Swap values in userform txtboxes
- Macro to FIND/REPLACE
- Data crunching according to criteria
- custom function color
- ello:
- insert label in worksheet
- leading zero issue when converting to time format
- startup macro does not execute
- Compile error - help
- Reading Chunks of Excel Data
- Prompt for saving a saved workbook
- MS Access Records
- Renaming Worksheet
- onmouseover event
- Where (menu) find "fill color" and define/add a new color?
- Run-time error ‘-2147417848(8001
- userform size
- Select a sheet and return
- Range referencing incorrectly
- Change Inches to feet and Inches
- fibbonacci series, with time function
- tooltiptext on textbox
- With statement question
- Can I use worksheet data in headers?
- HOW DO I ADD ONE COLUMN TO A SECOND WITHOUT DELETING THAT VALUE
- Creating working with Class
- Speaking error?!?
- Macro in add-in runs depending on if sheet exists in workbook
- Copy Name Range in single Cell
- How to apply SQLOpen Function - Excel 2007
- Numbers in words
- Selecting a worksheet
- Problem with formula
- parsing email address into another email string
- Remove an inserted picture
- Array Code issue
- how to write this in vbe ???
- Remove shape at series point (2007)
- Fill Array from a Range
- Get the Name of the Add-In Workbook used as a Reference
- How to Fill a String Array
- Extracting Specific Numbers in a String of Text
- Inset a picture
- Hiding All Checkboxes when I open/close the workbook
- Text to Columns - Saving User Settings
- Hide/Unhide CommandButton by cell criteria
- Track Changes using xlt file.
- Creating Custom Menu in Personal.xls Workbook_Open
- Macros always available in Personal.xls?
- Userform Question
- Update Access 2007 Table Using Excel 2007 VBA
- Save As Macro
- Modifying a range of cells
- Difference between times (Answer in minutes)
- Set Array equal to Range
- Searching across columns
- Product of 3 Cells based on criteria
- How to replace the background color of all cells from light green to light blue?
- filter
- .bat file to enter password protected .xls sheet
- COUNTIF accross multiple worksheets issues
- scroll so that the upper left cell in a range moves to the upper left of the active window
- select cell after sorting
- Macro should run on a specifi time.
- chart range to include variables - Macro
- Cell = "YES" then CommandButton2 Visible
- Keep the track of persons how opened the sheet and made changes.
- How do I require data entry in a combo box in Excel?
- How to code "Switch Row/Column" for Excel Chart
- setting constant path
- Command Button not copying with attached macro, help
- How to inhibit non-interactive MsgBox display
- copy data
- refresh combobox
- What am I doing wrong with Ranges named within Macro...
- Excel 2003 & 2007 menu compatible menu by Ron de Bruin
- Hidden Characters
- Auto height adjustment to fit on a single printed page
- excel unique values in column
- isolating TaskPanes between documents
- Can you make Range Equal All Values in an Array?
- Using Excel as Interface for big SQL Server Tables?!
- sheet selection without knowing name
- Trapping errors.
- Put numbers in column B cells when Value Change in Column A cells
- Can Sendkeys be used to send a selected no. of characters in a sin
- Delete selected worksheets
- DDE automatic refresh
- Application.Speech.Speak
- Nothing selected in my list box?
- Interior color disappears
- Count Dates in a range
- Code to assign a macro to hundreds of option buttons at once
- Please help with macro
- Last cell in active row--I know, I'm sorry
- Custom Function Add-In not working
- RE: Last cell in active row--I know, I'm sorry
- :
- Macro Letters
- workbook event, only to certain sheets
- Populate Combo Box with Values from CSV File
- macro's with if function included
- C# Excel Named Range Cannot be Found Due to Web Service Data Delay
- Can Excel Link two tables on seperate sheets?
- cells with null or no data
- copy shortcut to desktop
- VB control's text/caption is ugly - keeps resizing
- Day test question
- vlookup few books
- Re: Split Print Area - One Page Print
- Runtime error 1004
- Merge Multiple Files
- named range
- VBA code does not copy and paste to next row for each zip code
- Capture the Source Address of copied data
- Average last seven if not zero
- Error Msg - Object variable or With Blockvariable not set
- If Range ("C22") <> = 0
- Order of Drop-Down Menus
- Can you Filter using names from a generated list???
- Where to store lookup table
- SENDKEYS and brackets
- PasteSpecial error message
- Find Workbook in multiple instances of Excel
- help Vba
- Blocking column insertion
- Automating mail merge from excel
- Macro for deleting rows and serialising the remaing rows
- Load Values from Worksheet to Userform Controls with Loop
- Macro
- Question about checkboxes
- Perform calculation in Excel and store in Access
- Date formatting
- Pivot Data fields - removal of all (value) fields
- Grouping data with VB script or function?
- Excel 2003 : Problem accessing childnodes in XMLDomElements
- Re: word wrap from shrink to fit
- Set a counta function result in a for loop (Macro Excel)
- Macro Help!!!!!!
- Merging cells and copy!
- Re: word wrap from shrink to fit
- Script works in forms element but doesn't in normal option button
- Seems a bug in setting Style.Orientation property
- Find & Replace with two condition in VBA
- How to create a Linked (text) table in xl vba to a .mdb
- Cell Color condition using IF... ELSE statement in Excel
- Calculating Average Daily Balances
- Does Rowfields exists?
- GetOpenFilename() errors
- I want to insert pictures from from file
- Bug in my code
- Underline and Bold 4th numeral
- Display data from a cell in User Form
- Need help on Excel 2003 Macro Visible Property
- Copy Column D from all worksheets in WB1 and paste in sheet1 WB2
- E+16 in number
- disable EXCEL macro runtime-error
- find and findnext
- Club membership list / database
- Volatile UDF not updating
- 3-position switch control
- Repeat Character in VBA
- Userform errors
- Replacing Values
- formula doesn't work
- find duped value <> 0 and change to 0
- Combine multiple cells into one cell.
- How to use Header "Text" as Sort Key
- re: optimization for formatting worksheets
- Char(10) or Char(13) in body of email
- Load Userform Control Values from Worksheet
- Edit Button image
- Macro stops running at an unexpected time
- Load Userform Values from Sheet with Array & For...Loop
- How to copy and paste a partial row (i.e. not the EntireRow)
- macro to find data from one sheet & copy in another sheet
- Paste values only
- Autochart top 20 percent
- Filling/referencing cells from User Form
- macro to send email
- Delete rows based on date criteria
- Assistance with Loop construction
- What's causing error message?
- Help with Slow Print Routine
- help on creating five folders
- VPN Connection
- Looping Checkboxes in Worksheet
- Excel 2000 and XML
- Macro to set an html anchor?
- Help! Ungrouping Excel Charts --> EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsberg?
- Re-driecting a pivot quarterly
- After getting value from a cell need to make five folders under th
- ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007
- Module protection & Shell issues
- remove duplicates, keeping latest dated record
- named range
- Auto Check-out / Check -in
- How can I create five folders after this with a spacific name
- Check Out / Check In
- Loop web query & pivot table...?
- block printing of defined tabs
- Searching in excel
- If 80 in column A and date >= today...
- how can i find ' as the first characture in a cell using vba
- C# and Excel: how to get reference to Excel VBA form
- Need SUBSTRING like function
- Autocad & excel
- Alternatives to VBA for Excel programming
- Controling Chart Names
- Event Handlers: Getting a handle to the calling object
- Excel Date Issue
- C# For Excel Courses - London UK
- rename & hide worksheet problem
- Name of Pivot Table
- My own fiscal year
- Precedent arrow - link number
- Code will not run
- Get data from existing sheets in workbook
- How to create an 40230 error in the VBA Project?
- microsoft script editor
- MS Query
- Cannot open 2 projects at the same time
- Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work
- HELP with macros
- Devolving code to a DLL
- How to disable keypress in combox?
- CDO and Exchange Server 2007
- Macro to change Userform Textbox Font attributes
- Can a vlookup be done on a 2 dimensional array?
- Zoom Q
- Consolidating Code
- RE: creating a new folder with a value of a cell on the C directory
- creating a new folder with a value of a cell on the C directory
- Inputting a formula with a Macro
- VB code to fill next available cell
- create a macro to move one cell to the right w/o specifying range
- Find and replace in code
- hep with Loop
- excell novice needs helps
- Print each column seperately in Excel
- error message
- Cell cursor neglect cellinfo.
- New to Visual Basic
- Insert Dynamic Formula
- vba script to logon to another application like iseries
- macro runs fine but error message is displayed
- Spreadsheet Object in VB Form (Excel 2007)
- Filling Zip by City
- How to select info based on date
- Shift down and then to the right
- How to use a pointer in an IF Statement?
- Invoking "cmd" from VB macro
- covert xls to xml
- r/t 2110 - Can't Move Focus to control
- Conditional formatting ... or VBA programming help
- VBA corrupting Cell A1 in CSV file
- How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from?
- UserForm cancellation
- ActiveWorkbook.RefreshAll
- Backup Addin
- Hyperlink
- Can't get rid of multiple project references in VBA
- code to mark coloured cells in excel
- Insert space before CAPITAL letters
- Error with Selection.CurrentRegion.Rows.Count?
- Ole timeout
- Method 'Range' of object '_Worsheet' failed in Union of 3 Ranges
- Formatting for the whole worksheet
- Worksheet CodeName property
- Screen Update
- Copy from a text box
- Programming on excel sheet
- deselect one of the shapes
- why won't this work?
- ShowAllData error
- Is my ListBox empty?
- message box on cell content
- conditional formatting
- Getting r/t error
- Last Cell In Row
- search locked cells
- Cannot Dechiper Encoded String
- Can you apply a comment to a range of cells (as opposed to just one) ?
- look to do an Offset of something like a offset
- Range problem
- Data Consolidate duplicates data...
- Rename Sheet tabs from list......
- Code error
- Outlook - Pull contact from Outlook into Excel
- Text Box colours
- Input Box
- Concatenation of Text
- Auto run macro when file is saved
- Run-time error 9 - Subscript out of range
- Helps on Custom Views
- a problem with savaas method
- Macro needed to copy groups of data from one spreadsheet to anothe
- Can I create a link from a cell to take me to another worksheet?
- Retrieve result of query from Access
- Varioable in SQL statement
- Switch to Excel workbook in a separate instance of Excel
- Populate worksheets fro a Master List
- macro not found, but it is there
- Data Validation
- macro not found, but its there
- Programatically get to Named Ranges in Name Manager (Office 2007)
- file name as specified cell when save as or save is clicked
- worksheet to track vacation accrual by employee and cost/job cente
- Copy Sheet causes Combo Box change event to fire on original sheet
- Should I use sumproduct function?
- Convert Decimal to Feet and Inches
- Excel Date Format Macro
- Access Data Entry Form
- data validation based on cell value
- Stop recording toolbar
- Code Takes Forever to Run - Why?
- Simple question concerning VBA functions
- vba unprotect sheets with different passwords Help Thank you
- extract right side of string
- Assign value with DOWHILE (variant of TRANSPORT METHOD)
- VBA connected vs disconnected from network?
- Count Uniques in Col H, Result in Blank Cell, For Each Next Loop
- Copying Worksheet to New Workbook
- Test for files existing
- Looking for a shortcut
- Email a statement
- display message while code is running
- Text Box Value From ActiveCell
- Using vbYes or If statement
- xlVeryHidden
- Syntax To Update ComboBox List From TextBox
- Query Problem with Read-Only Workbook
- VBA Excel how to assign name in variable range
- Formatting via VBA
- Shift the Left Boundary of Named Ranges when Inserting Columns
- How can I use Shapes in 2007?
- Comparing Wookbooks
- LOOKUP PROBLEM
- Consolidating Ranges on different sheets using VBA
- VLookup error - Sub or function not defined
- How to sign a Macro
- Paste Special error in a Macro
- Command button color
- Compile error: Variable not defined
- rename a worksheet adding a sequential number at the end
- Find consecutively and copy
- Error when copying worksheets
- .pictures documentation
- Search and find all "$" in a string
- Need help with *lookup*? (or something else) for making a calendar
- Worksheet_BeforeDoubleClick Stops Working
- Get Active Object or Textbox Name to pass to sub
- Deleting original sheets
- SpecialCells(xlCellTypeVisible) driving me nuts
- Help to copy files names in a column from one directory to another directory VBA
- Excel VBA Print Command
- Hide Sheet when cell equals
- userform dragging problem
- Shif cells to the right and down within limits
- How to disable tempory an automatic Worksheet_Change Event
- Worksheet Change Event Triggering Multiple Times
- mean calculation of each column of each group
- Scroll bar update
- Scroll bar with text box
- Bad File name or number
- Unable to set the LeftHeader property of the PageSetup class
- Sorting data using 2 seperate columns
- XL 2007 GetEnabledMso("Undo") is always True
- how to insert microsoft equation 3.0 with vba
- Has AutoFiltering Been Applied?
- creating and saving data from a userform
- mark to market
- Re : Excel HyperLinks to WorkSheets & Chart-Sheets
- Array sorting
- Network DDE between two excel
- Getting the Kalendar Week within VBA
- Filter or Sort??
- VBA Source code librarian or versioning system
- Re: Ungrouping Excel Charts --> EMF/WMF. 2007 can't edit objects as 2003 (freeform big issue). Steve Rindsberg help!
- Slow code to copy a row x # of times
- Combobox
- Webpage conversion
- Certificate breaks when file is saved
- Prevent User from saving Changes to a spreadsheet
- Exporting Chart sheets as gifs
- Auto calc. the bottom 20% with a twist...
- External:=True
- How do I identify range of filtered sheet?
- Stop a user navigating certain sheets
- ribbon question
- Working with Range
- Deleting rows when cell text reads "Research"
- can vba look up a value in the f distribution tables?
- SQL Syntax
- Show Minimum value
- Worsheet selection
- Select entire rows if between date/time range
- Autofilter not working with multiple field selections
- Can the Text on a button form be referenced from a cell?
- Save ONLY 1 Sheet in a Shared Workbook
- drop down list in .htm format
- Listbox - works 1/2 time
- clipboard - backup and restore
- For/Next Text to Columns
- Strange formatting on one machine only
- Find row and delete following rows
- How to get the current module name and Sub in VBA?
- Switch to diff workbook with file name LIKE based on value in a ce
- Code to find the max value for a cell while looking at other cells
- run time error when inserting Excel sheet into word document
- I want to learn excel programming
- iterate my rows
- Can I make Bills of Material that deducte given QTY's fron invant
- Active Sheet Error Message
- Run Time Error '1004' General ODBC Error
- Putting wordpad document into cell office 2003.
- updatelinks method?
- access selective data...using query
- New Sheet based on condition
- conditional formatting Do anyone have a work around for this probl
- Auto Ranking
- Linking xlb file to xls programmatically (or other trick)?
- Formula to hyperlink to match
- VBA - Select: current cell + next 19 cells (down in column) = rang
- Time Range Summary - parse data
- pickup the amount from the workbook
- Save embedded object?
- Conflicting event procedures launching at the same time
- Select row in formula in excel 2007
- skip actions within a macro if a cell value is zero
- Scroll bar (Floating, Changing Sheets)
- Protect a shared workbook
- Creating Word docs from Excel with VBA
- Gain senders email address from an email sent to me
- Using Dir function to find folders
- Axis title text direction stacked
- Freeform Object Failing
- Automate the Tools...Reference ?
- Excel keeps shutting down using code
- Need help creating a count macro
- Macros
- Help with a loop please.
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.