1401:
Textbox
1402:
Prevent code running
1403:
How to desensitize the "X" on Inputboxs, Textboxes and other gui's
1404:
How to desensitize the "X" on Inputboxs, Textboxes and other gui's
1405:
Select cell after last row in selection?
1406:
XLL Help
1407:
function doubt
1408:
Help Required 4
1409:
code for a formula
1410:
Search and change font color to Red and bold it
1411:
Macro to delete ROWS in a spreadsheet using Text file
1412:
Problem with pivot table when workbook is protected
1413:
Reference books
1414:
Delete text when font is color black
1415:
VB Array - Select column
1416:
delete coding for excel 2007
1417:
Passing an array in a user defined function
1418:
square root
1419:
How to get a reference to the Excel application inside a class
1420:
Loop through worksheets
1421:
Load Values from a Range into a List Box
1422:
HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/
1423:
Comment / wav file
1424:
How detect if any workbooks are open?
1425:
MOD function results
1426:
Excel VBA reference docs?
1427:
Send Data From Active Sheet to Closed Sheet on Network
1428:
how to find URL in Excel 2007
1429:
email
1430:
interior.colorindex does not work?
1431:
VB script email
1432:
How can I execute Shape drawing Excel 2007?
1433:
Quick Help!!! - remove character at position "X"
1434:
Using a WILDCARD (%) in the SELECT clause
1435:
Macro runs faster when VB code window open
1436:
Using Get with very large file
1437:
Calculating Number of Rows for Merged Cell Text Wrap
1438:
pdf to excel
1439:
Followup to Dave Peterson search routine from 4/15/08
1440:
Can I change the format of numerical & specific word references
1441:
Returning FileLen with very large file
1442:
formula
1443:
incredibly dificult formatting problem
1444:
using if formula on page 2 to post answer on page 1
1445:
abt computer operator
1446:
Average of cell values - Ignore if 0
1447:
XLL help
1448:
Other program disabling my custom toolbar
1449:
Dual Code
1450:
Conditional Formatting for a row
1451:
select case issue
1452:
Microsoft Excell
1453:
Get data from browser
1454:
Move data from text box to cell
1455:
timer issue
1456:
How to set primary key property in a column
1457:
PivotCache.CommandText
1458:
Problem with before close
1459:
RegExp & VB Noob Qs
1460:
Macro 2 insert formula if part of cell contains specific text
1461:
Extract sheetname and data from each sheet
1462:
Problem with find function
1463:
check if hyperlink still works
1464:
Integrate Outlook with Excel
1465:
Modifying Ron's codes (Again...)
1466:
xla is opening the corresponding xls
1467:
Sendmail and Lotus Notes trouble
1468:
Using J1.value to print single label
1469:
Excel: use J1.value to print out one label
1470:
Stop / Pause a Macro using Pause button
1471:
SINGLE variable question
1472:
Removing the CR DB trailer from a number xx.xxCR
1473:
filling 2D array with no-zero values
1474:
syntax question
1475:
Paste Value into separate workbook
1476:
xla and ActiveWorkbook.Save
1477:
VB Chart
1478:
What is 'Me'...?? I don't get what it is referring to in this sub
1479:
Find 2 values in adjacent columns simultaneously
1480:
Calculation mode .Net
1481:
Generate Excel Scatter Diagram
1482:
Return Print Area Range
1483:
Defining Strings using Dim or Const
1484:
Adding Tip Text to custom toolbar in 2007
1485:
How to get in a vbs script the sum of values of a Excel cells in a certain range?
1486:
ClearContents terminating macro - using 2 workbooks
1487:
ClearContents terminating macro - using 2 workbooks
1488:
xla files
1489:
Strange problem with HPageBreaks
1490:
Command Button
1491:
Macro Not Running in Excel 2007
1492:
ActiveWorkbook.RefreshAll Problem
1493:
Add a constant value to a range of cells during a copy macro
1494:
Help Required 3
1495:
Help Required 2
1496:
Last cell on printed page
1497:
Lottery Checker Conditional Formatting
1498:
Help Required 1
1499:
File Menu
1500:
Remove Hyperlink
1501:
User defined function
1502:
Force a new instance of excel to open
1503:
Dynamic Pivot
1504:
Copy visible cells after filtered paste to first empty cell
1505:
Auto Date that doesn't change
1506:
Spaces in data entry
1507:
Issue deploying C# assemblies for Excel (com reg issue)
1508:
Loop not working properly
1509:
How do I get this macro to start the search in the second row
1510:
Export Excel Data to Xml Output
1511:
Excel - oleDB - DataSet
1512:
Gaussian de-convolution
1513:
Stop looping macro
1514:
VBmodeless user form errant behaviour
1515:
Set an Add-In to This Workbook module
1516:
Command Button
1517:
Find top 10 items in a range
1518:
Custom Toolbar Add-in
1519:
Here's a big ask
1520:
Excel with OLEDB and Ado.Net - Single quote problem(')
1521:
Filter First Record
1522:
Putting text together from 3 cells
1523:
Call Outlook Contacts from Excel Userform
1524:
Excel spreadsheet still pointing to old server after server move
1525:
Error 1004 after copying 84th worksheet to a new workbook...
1526:
Macro: how to create label forms inside the worksheet not userform
1527:
save\change sheet name
1528:
Automatic GETPIVOTDATA formula generation from within VBA?
1529:
Excel 2007/Excel 2003 compatibility
1530:
Ignoring cells using IF
1531:
Text String
1532:
Copy two ranges without the interval rows to the email
1533:
Select the current region excluding the top row
1534:
Changing colour bases on another sheet
1535:
Any help is appreciated Creating New files from One File
1536:
Comparing data in columns for Non-Matches
1537:
Problem with Subs and If's !
1538:
Learning VBA-don't understand error message
1539:
macro opening too many files at once.
1540:
Array() function whacks out Excel 2007
1541:
finding duplicates
1542:
Inverse prediction
1543:
Accessing the excel 2007 context menus...
1544:
Help needed with Modifying 2 Macros
1545:
Merging cells
1546:
Best way to wait
1547:
Countdown Timer Followup
1548:
Permission denied when copying file
1549:
range row
1550:
automaticaly change script
1551:
Automatically hide/unhide rows
1552:
Cell Reference Changes According to Project
1553:
Clean up code and port to Mac
1554:
Access converts "!" to "$"
1555:
Ignoring Cells through IF Functions
1556:
Automate Excel export to a CSV file
1557:
Update a range in a sheet click event (Excel 2003)
1558:
Multiple criteria for moving a row to new spreadsheet
1559:
fix basic macro to filter blank data
1560:
Copy active sheet tab
1561:
VBA and Office Question
1562:
Paste just the Value
1563:
Name Issue
1564:
Has the Excel 2003 OLE model changed over SPs?
1565:
Large & Vlookup functions
1566:
Icon on Taskbar
1567:
Concatentate A1:AZ1 separated by ~
1568:
Hiding Data points Equal to Zero
1569:
Help needed with Very slow code Please
1570:
Adjustable Axis in Excel 2007
1571:
Visual Basic Chart Objects array
1572:
Delete all Blank Rows from data table
1573:
Combining multiple like's with Or?
1574:
Understanding R1C1
1575:
Found a workaround
1576:
Merging two files with different time stamps
1577:
Sorting numbers
1578:
copy data from new worksheet to master list
1579:
Sorting text strings
1580:
Clear status bar message in bottom left hand corner
1581:
worksheet_change help
1582:
Importing Sheet
1583:
Importing Data into an Excel sheet-template
1584:
Copy cell based on unique value - alternate rows - into 1 row,....
1585:
Copy cells up - based on ID??
1586:
How to search for "#N/A" in Excel VBA
1587:
Excel 97
1588:
V2003 Macro not working in V2007
1589:
Copy rows with today's date to new sheet
1590:
VBA Excel range name test
1591:
How to sort
1592:
Want to auto filter with date on daily basis
1593:
Controlling Auto filter
1594:
Data need to be copied as per sheet name
1595:
SaveAs Type Problem
1596:
compatibility issues w Excel 97-03 to 2007
1597:
Changing color
1598:
Halt / Stop processing when a user selects Cancel
1599:
About Application.OnUndo again
1600:
Auto Right Click
1601:
Custom Right Click
1602:
VANILLA ICE FANS ONLY
1603:
Macro for event procedure
1604:
Drop down menu / list
1605:
separate data with extra column
1606:
Naming Of Sub Procedures
1607:
Pulling data from Access
1608:
Maximized Workbook
1609:
Greater than less than in a find function
1610:
Unique records excel
1611:
Xors and byte arrays
1612:
Need equivalent code for 2007
1613:
Excel App gets focus
1614:
named range/offset
1615:
EOMONTH not allowed in Array Functions?
1616:
how can I delete rows based on column value
1617:
How to do something in an VBS script for all worksheets of an Excel file?
1618:
Followup to RonDB "Modify Copy4" discussion from June 19th
1619:
Selecting data in tables, if not given then interpolating
1620:
sum true/false
1621:
My Macros will not work after I protect my document.
1622:
DNS-Less Connection String
1623:
Deleting pasted HTML controls with Javascript
1624:
Watch Window disappears and not available but Immediate and Local
1625:
Huge spreadsheets, anything I can do?
1626:
foce region to print on one page
1627:
loop?
1628:
Copying modules from one sheet to another, in code?
1629:
Can excel convert a date to text
1630:
VBA code for check boxes in a form
1631:
Refedit
1632:
Closing application problem
1633:
adding bold to formula cell
1634:
Using IF to refernce another cell
1635:
Application event for Chart selected/activated?
1636:
Radio Button Selection on Auto Open
1637:
"If" Formula in VBA
1638:
Dynamic Range
1639:
changing constants
1640:
Reason to Answer Questions in this Forum
1641:
Dim cht as Object Constant Declaration
1642:
is there an easier way to update?
1643:
Opening file cause rows to lose
1644:
Create Function which returns an Array
1645:
Close UserForm by pressing Esc key
1646:
Worksheet_Change
1647:
Blinking Text in the UserForm
1648:
Convert numbers to words, 3=ship, so if I enter 3, it says ship.
1649:
Reorganising Data
1650:
How do you trigger an "On Click" event programatically
1651:
Need help converting macro from 2002 to 2007
1652:
Conditional Borders through a Macro
1653:
VBA - entering a formula in excel
1654:
Fill Color
1655:
Userform
1656:
Macro to copy from another workbook
1657:
conditional formating bold is true not bold false how
1658:
Test if macro is called by another macro
1659:
How to search in VBA?
1660:
Macro Textbox accross worksheets - wont work!
1661:
subquery to keep maximum date
1662:
Activate Condition When Another Cell Is Selected
1663:
text wrap is not stable
1664:
Dynamic Sorting Lists
1665:
show all data issue
1666:
VBA help for simulation
1667:
Having trouble changing the Locked status
1668:
Excel VBA help to test the activecell.value
1669:
Option Private Module
1670:
control excel in c++
1671:
Problem to use Excel remotely
1672:
VERY tricky timer question
1673:
Full Screen
1674:
ADO read to and array
1675:
Update database from ODBC query (or another method)
1676:
How to Remove Duplicates and Replace with Blank cells in excel ?
1677:
Unable to set the Visible property of the Worksheet class
1678:
Need help reversing a formula...
1679:
COMBINING WORKBOOKS
1680:
Help With Pivot Tables
1681:
ControlSource question
1682:
Prior macro not working in new location after some alterations
1683:
Force a SaveAs
1684:
Calculate age in years and month or decimal
1685:
Need urgent help with VBA 2007 CHARTWIZARD method !!!
1686:
Hiding rows with merged cells
1687:
Excel files
1688:
Userform and textboxes
1689:
For/Next Loop
1690:
search method
1691:
Application 1004 error
1692:
Inserting colon as text
1693:
Rows won't hide?
1694:
If Function ignoring rest of formula
1695:
Hide Every Thing during UserForm Loads
1696:
Code fails after upgrading to Office 2007
1697:
COM Shim in VS 2008?
1698:
Radio buttons: "mutually exclusive" property?
1699:
SelectionChange/ toggle sort visible rows
1700:
Calculating average of percentages
1701:
Simple Chart name modification Not working
1702:
Calculating once, daily
1703:
Copy conditional format from one sheet to another using VBA
1704:
Changing tab color continued
1705:
Extracting values from Freeform shapes
1706:
Makro from value in one cell, hiding columns in another sheet
1707:
Option Buttons and Combo Bars
1708:
I have no idea how to start this.
1709:
Looking up a table value based on two conditional option buttons
1710:
Calculating Difference between ranked values within random range
1711:
VBA help
1712:
No idea how to start this.
1713:
Delete worksheet if cell is empty
1714:
Requiring "Explanation" when changing number in cell
1715:
Workbooks.Open using Dialog box
1716:
How do I change the dates?
1717:
Macro to change color of tab based on color of cell
1718:
Default autofit contents for comments in excel 2007
1719:
Center Text on Point
1720:
dependant summing
1721:
how to Hide/delete dynamically created button?
1722:
can excel automate text-based screens?
1723:
Close a particular Word file from Exce;
1724:
Another User
1725:
Countdown Timer
1726:
identify selected worksheets
1727:
Two Monitors
1728:
HLOOKUP problems
1729:
Simple Macro help
1730:
Worksheet_Change event problem
1731:
How do i copy a sheet from one workbook to another using VB
1732:
Workbook_Open operates correctly in single step but not when run
1733:
Selecting Contiguous Ranges on a Sheet
1734:
Automation Interface use
1735:
Mapped Disk Full Error Message
1736:
printing issue/macro needed
1737:
finding transverse cell in excel
1738:
splitting a string
1739:
Input box question
1740:
Pivot Table Type Mismatch when More than 65536 rows
1741:
Chart Axis Modification
1742:
Addition of user functions in function wizard.
1743:
Look up - HELP!!!
1744:
BubbleChart XP vs VISTA
1745:
Sheet Within Sheet
1746:
How to programmatically add a non standard custom cell format
1747:
repair hyperlinks / testing for invalid address
1748:
debug automation add in written in VS2005 for excel 2003
1749:
cycle through checkboxes
1750:
Displaying possible combinations