Home > Excel Help Portal > Programming Excel

<<  (Page 18)  Previous              Next  (Page 20)  >>

Programming Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to program
Microsoft Excel using VBA.

901. Make the Header Row stay visible as you scroll through data
902. Date and Time Tutorial
903. On Error Resume Next Takes Longer to Run Than in Excel 97
904. Keeping a running total in an adjacent column
905. Add a Certain Number to All Numbers in a Range Using Paste Special Add
906. Setting a font name with VBA
907. Freeze pane for select rows and columns
908. Stamp Auction application -- Dialogs, input boxes, UserForms
909. Automatically add a character in a cell
910. Subtotal without grouping
911. Parsing Dates
912. Ranking without repetitive ranks
913. How to calculate and display the largest value
914. Color Unlocked Cells
915. Trap Those Errors
916. Have an IF statement return "Yes"-"No"
917. Protecting specified data using VBA
918. Split the contents of one column into two columns
919. Custom Dialogs
920. Using the Analysis ToolPack
921. Freeze the Headers so they are always visible as the cell pointer scrolls deeper into the worksheet
922. Change the worksheet tab name to reflect the value in cell A1
923. Keeping Excel from changing data to dates
924. Link Chart to Worksheet Range
925. Apply Styles to PivotTables
926. Returning specific data on examining a range
927. Hiding a range depending upon user selectons
928. MrExcel's Recommendations: Word help
929. Importing Text Files into Open Workbook
930. Select Custom Header
931. Conversion of Feet and Inches to Decimal Values
932. Working with Userform controls
933. PivotTable to Calculate Budget Variances
934. Splitting the contents of a cell/column into two distinct cells/columns
935. Splitting the contents of a cell/column into two distinct cells/columns
936. Trapping VBA Errors {Part 2}
937. Use MathEasy Add-In to simplify entering math formulas
938. Exit a worksheet with or without saving
939. Removing a set number of characters from a cell
940. Saving a chart as a GIF file
941. Learn How to Add Running Totals to a Worksheet
942. Returning Zero instead of #N/A
943. Using Inputboxes
944. Dialog Box to Filter Data
945. Working with Dates
946. Formatting Time Values
947. Removing hyperlinks from a worsheet
948. Tabbing through specific cells
949. Removing hyperlinks from a worsheet
950. Change Cell Formatting

<< (Page 18)  Previous              Next  (Page 20) >>