PDA

View Full Version : Excel Help



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

  1. [SOLVED:] Worksheet Function Change Row Colors According to Value
  2. [SLEEPER:] Help with a VBA Print Range Code Problem
  3. [SOLVED:] Validation
  4. [SOLVED:] Custom menu (Office 2002)
  5. [SLEEPER:] .OnAction = "Macro" Syntax for COM Addin
  6. [SOLVED:] Get Underlying Hyperlinks Out of Friendly Names
  7. [SLEEPER:] Paste from Word to Excel
  8. Advice: Newbie to VB.. auto run code worked in XL 97 but not in 2003
  9. [SLEEPER:] Automating some functions
  10. [SLEEPER:] Unbuttoned
  11. [SLEEPER:] Charts' attributes and methods
  12. [SOLVED:] Toolbar to Run From Addin
  13. [SOLVED:] Validation List or a Combo Box
  14. [SOLVED:] Help with datepicker control
  15. [SOLVED:] Change From Print (Range) To Select (Range)
  16. [SOLVED:] Hide/Unhide Worksheet
  17. Solved: Email Workbook without macros
  18. [SOLVED:] Create txt Backup
  19. [SOLVED:] Userform hyperlink
  20. [SOLVED:] Emailing Multiple Worksheets
  21. [SOLVED:] Conditionally Reducing Choices in Multiple Combo Boxes
  22. Added (jobs): Automating Emails from Excel
  23. [SOLVED:] Writing SQL Queries Against Virtual Tables in Excel VBA
  24. Advice: Email Using Composition Header and Envelope Toolbar Button
  25. [SOLVED:] How do I Check if a workbook is opened??
  26. Advice: Dynamic named range Discontinuous, Non-VBA
  27. Advice: Custom Menu Woes
  28. [SOLVED:] Daxton's Question: New Worksheet Button on Every Worksheet
  29. Advice: Using Sendkeys to delete Styles
  30. [SOLVED:] Get Web Stats with Webalizer and Analyze
  31. [SLEEPER:] Putting the cursor into the textbox
  32. [SOLVED:] Updating Source Range of Pivot Tables
  33. [SOLVED:] Clear Clipboard Contents
  34. [SOLVED:] Customize a Formula Based on User Input
  35. [SOLVED:] Excel AutoNumber Files
  36. [SOLVED:] Highlighting Duplicates
  37. [SOLVED:] Add to Make a String
  38. [SOLVED:] Combine Worksheets into One Master
  39. [SOLVED:] Show a Formula in Another Cell
  40. [SOLVED:] Addin menu creation
  41. [SOLVED:] Create New Workbook From Existing (minus some sheets)
  42. [SOLVED:] Character Count
  43. Advice: Help with Msgbox
  44. [SOLVED:] Remove Right-click Menu Custom Item
  45. [SLEEPER:] Problem opening Huge XLs file
  46. [SOLVED:] Hide Rows Where Column A = Zero
  47. [SOLVED:] Unprotect Worksheet
  48. [SOLVED:] Amendment to Existing Macro
  49. [SOLVED:] Editing Access Records from Excel / ADO DAO
  50. [SLEEPER:] Embedded Objects and ControlTips
  51. [SOLVED:] Filtering based on criteria
  52. [SLEEPER:] Function that uses UDT (User Defined Types) - Can't Complile?
  53. [SOLVED:] Putting the worksheets in order...
  54. [SLEEPER:] Opening a form from a combobox
  55. [SOLVED:] Looking for fast VBA alpha sort
  56. [SOLVED:] Input masks
  57. [SOLVED:] need explanation of coding frames in vba
  58. [SOLVED:] Create random passwords for each of my customers in Excel
  59. Sleeper: Hyperlink - Using SAME Browser Window
  60. [SOLVED:] Auto Refresh Pivot Table on Activate Worksheet
  61. [SLEEPER:] Hints, Tips, Suggestions On Office 2002
  62. [SOLVED:] Lookup using a list box
  63. [SOLVED:] Inserting a Range into Footer
  64. [SLEEPER:] VBA TextBoxes Yahtzee
  65. [SLEEPER:] Creating Logo Via Userform Input
  66. [SOLVED:] Refresh Pivots w/ Remote Data
  67. [SOLVED:] Left(), Right(), Trim()
  68. [SOLVED:] Finding empty cell
  69. [SOLVED:] make a macro menu in excel
  70. [SLEEPER:] Moving data
  71. [SOLVED:] Documentation?!?!?
  72. [SOLVED:] Loosing new VBA functions when I quit Excel
  73. [SOLVED:] fun work in progress...
  74. [SOLVED:] VBA hiding and locking rows?
  75. [SOLVED:] Blank cell macro problem..
  76. [SOLVED:] Loop through records to concatenate
  77. [SOLVED:] Deselect or Remove from Range?
  78. [SOLVED:] Question about concatenate
  79. [SOLVED:] Cancel Button for Input Box
  80. [SOLVED:] Removing Duplicate Entries in a Column
  81. [SOLVED:] UDF text case
  82. [SLEEPER:] Checkbox captions
  83. [SOLVED:] Delete All Comboboxes
  84. [SOLVED:] changing cells based on dates
  85. [SOLVED:] Source Data for Graphs
  86. [SOLVED:] Customized sort
  87. [SLEEPER:] Changing notes to outlook
  88. [SOLVED:] Checking Cell in Range
  89. [SOLVED:] Populating 3 Dimension Array
  90. [SOLVED:] UDF loop needed
  91. [SLEEPER:] E-mailing excel cells in body of e-mail
  92. [SOLVED:] DLL add-in registration
  93. [SOLVED:] Checking to see if a variable is = to another variable
  94. [SOLVED:] Create an .XLA file
  95. [SOLVED:] Stop pop-up when excel closes
  96. [SOLVED:] Filter out dead columns
  97. [SLEEPER:] Search for any character
  98. [SOLVED:] Conditional MIN and AVERAGE
  99. [SOLVED:] Auto Calculation Toolbar Button
  100. [SOLVED:] A B C = Jan Feb March
  101. [SOLVED:] Assign a Macro to a Button
  102. [SOLVED:] UserForm Right-Click Menu
  103. [SOLVED:] Concatenate via code..
  104. Advice: Macro Cell reference Range vs Active Cell
  105. [SOLVED:] Back button
  106. [SOLVED:] Passing the Used Range to a range object...
  107. [SOLVED:] Funky Formula to VBA conversion
  108. [SOLVED:] Forward and Backward Chronologically...
  109. [SOLVED:] Open hyperlink from VBA code
  110. [SOLVED:] VLOOKUP, Edit Results, Paste Changes
  111. [SOLVED:] Using named ranges in other workbooks?
  112. [SOLVED:] Advance Filter Copy to Range
  113. Solved: Printing Options
  114. [SOLVED:] filter and send...
  115. [SOLVED:] How to create subset of unique items from array
  116. [SOLVED:] Embedding Excel Cells On a Userform
  117. [SOLVED:] Clearing Array contents
  118. [SOLVED:] Do..Loop help
  119. [SOLVED:] Data Source validation
  120. [SOLVED:] To SUBTOTAL or not to SUBTOTAL?
  121. [SOLVED:] Creating simple games in Excel
  122. Vacation Calendar
  123. [SLEEPER:] Automated Label Printing with Word
  124. [SOLVED:] Cell To show Data rather than a reference link
  125. [SOLVED:] Delete certain rows
  126. [SLEEPER:] Adjusting User Form size to coincide with screen resolution
  127. [SOLVED:] Declaring Variables in Excel VBA
  128. [SOLVED:] Question about focus
  129. [SOLVED:] New problem (AutoCopying)
  130. [SOLVED:] Code to Cover Non-Contiguous Columns
  131. [SOLVED:] Graphing Problem
  132. [SOLVED:] Why does it start in A2 not A1?
  133. [SOLVED:] Comparing two cells minimum 4 continous Characters match
  134. [SOLVED:] Define Certain Exact Range
  135. Advice: LookUp as macro
  136. [SOLVED:] Attaching Macro to object when emailing workbooks
  137. [SOLVED:] Macro To Vlookup End Insert value
  138. [SOLVED:] help with autofilter
  139. [SOLVED:] Calling function from add-in
  140. [SOLVED:] Can I - if a check box is not selected, cell range = zero
  141. [SOLVED:] Want 2 Protect sheet - but Checkboxes are too :(
  142. [SOLVED:] Protect Sheet but still insert comments
  143. [SOLVED:] Finding a record
  144. [SOLVED:] Help with a loop
  145. [SOLVED:] Preventing a form from closure
  146. [SOLVED:] Help format report
  147. [SOLVED:] Help to generate a subtotaled report
  148. [SOLVED:] Calling a macro from another macro
  149. [SOLVED:] Duplicate Finding between 2 sheets
  150. [SOLVED:] Insert a New Row
  151. [SOLVED:] Which control had focus?
  152. [SOLVED:] This Any Use To Anyone??
  153. [SOLVED:] Printing Macro
  154. [SOLVED:] Optimising file size
  155. [SOLVED:] File Print Macro
  156. [SLEEPER:] Some copying questions
  157. [SOLVED:] Create VBA add-in
  158. [SOLVED:] Stop user from closing workbook until conditions apply
  159. [SOLVED:] Worksheet Zoom property
  160. [SOLVED:] Can't delete addin
  161. [SOLVED:] On Error GoTo
  162. Sleeper: Pesky RefEdit box
  163. [SOLVED:] combining related records into one
  164. [SOLVED:] Retreive Add-in path
  165. [SOLVED:] Nice Print Macro
  166. [SOLVED:] Kill Macro from UserForm
  167. [SOLVED:] Email worksheet as TXT or as CSV
  168. Advice: Add-in with Forms
  169. [SOLVED:] Custom Data Type ?
  170. [SOLVED:] Script works in Excel but not in 1-2-3
  171. [SOLVED:] Tracking Steps through an Order
  172. [SLEEPER:] Grab a Label
  173. [SOLVED:] Testing help wanted!
  174. [SOLVED:] Remove listbox item
  175. [SOLVED:] Clearing Contents of Merged Cells
  176. [SOLVED:] Add Reference
  177. [SOLVED:] Move Y avis to left of chart
  178. Sleeper: Grouping/Positioning Charts
  179. [SOLVED:] Inputbox - Cell/Range selection - Nothing selected or Cancel
  180. [SOLVED:] object variable or with block variable not set
  181. [SOLVED:] Index/Match Help
  182. [SOLVED:] Copy cell without border
  183. [SOLVED:] Solver.xla
  184. [SOLVED:] Adding New Menu
  185. [SOLVED:] Creating a Userform
  186. [SOLVED:] Conditionally formatted chart
  187. [SOLVED:] How to exit a combobox on KeyPress
  188. [SOLVED:] Userform textbox scrollbar
  189. [SOLVED:] Multipage Focus on UserForm
  190. [SOLVED:] Protect Individual Cell with Formula?
  191. [SOLVED:] INDIRECT Reference
  192. [SOLVED:] Userform scrollbar in frame
  193. [SLEEPER:] Loop
  194. [SOLVED:] RegExp help!
  195. [SOLVED:] Insert rows above designated values
  196. [SOLVED:] Solved: VBA Reference Missing
  197. [SLEEPER:] Link Data to Access DB
  198. [SOLVED:] Using Named Ranges
  199. [SOLVED:] Auto import/link to CVS data
  200. [SOLVED:] Finding Sort Order
  201. [SOLVED:] Problem with decimals in VBA code
  202. [SOLVED:] Initializing variables
  203. [SOLVED:] Unusual Command Buttons
  204. [SOLVED:] IF Formula Using Label
  205. [SLEEPER:] Import of txt file generates error 1004
  206. [SOLVED:] Creating a Static Chart
  207. [SOLVED:] Excel day of week conversion
  208. [SOLVED:] Array Problem
  209. [SOLVED:] Help with cell display, sheets loop
  210. [SOLVED:] Stay on Top Userforms for Excel
  211. [SOLVED:] Problem running code on a different sheet
  212. [SOLVED:] Sum during the importing...
  213. [SOLVED:] Odd things between runs...
  214. [SOLVED:] Create string for Messagebox
  215. [SOLVED:] Formula based on files in directory
  216. [SOLVED:] Excel/VBA crash
  217. [SOLVED:] VBA App for producing Unit Circle values
  218. [SOLVED:] Header Font
  219. [SOLVED:] FIND AND INSERT SI NO
  220. [SOLVED:] ComboBox in Command Bar
  221. [SLEEPER:] How to encrypt vba code on the fly
  222. [SOLVED:] Error when setting Interior ColorIndex
  223. [SOLVED:] Positioning of userforms
  224. [SOLVED:] Checking and correction values in userforms
  225. [SOLVED:] Adding code to worksheet module
  226. [SOLVED:] Format in TextBox
  227. [SLEEPER:] Attending the end of macro....
  228. [SOLVED:] VBE help
  229. [SOLVED:] Find text in Excel workbook
  230. [SOLVED:] Help with An Activecell Error
  231. [SOLVED:] Formatting & Custom Toolbar
  232. [SOLVED:] Scroll Bar in Userform Wipes Data in Cells
  233. [SLEEPER:] VBA Script Resources
  234. [SOLVED:] Setting range syntax
  235. [SOLVED:] Interactive Data Entry in Excel
  236. [SOLVED:] Strange error message
  237. [SOLVED:] Range.Cells.Range.Cells
  238. [SOLVED:] Formatting Text Boxes in UserForms
  239. [SOLVED:] Keeping last entered values in a wizard
  240. Create Import Wizard for Text Files
  241. [SOLVED:] Avoid Loop to Find (and replace) empty cells
  242. [SOLVED:] Count Occurrences of Letter w/in Cell?
  243. Listing available files and Downloading from FTP site
  244. [SOLVED:] Msgbox to open when excel closes.
  245. [SOLVED:] Programmatically Erase Data in Merged Cells
  246. [SOLVED:] Hide / Show worksheets Based on Multiple Criteria
  247. [SOLVED:] Recopy Without Duplicate And Insert In Form
  248. [SOLVED:] Using the AND command
  249. [SOLVED:] Adding comment to excel / outlook script
  250. [SOLVED:] Reminder Messages before Workbook Close