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:] Exporting to Excel
  2. [SOLVED:] Help with Number Custom Format
  3. [SOLVED:] Changeing links source with VBA
  4. [SOLVED:] Can I increase date/time with +/- key
  5. [SOLVED:] Help with macro to bold word
  6. [SOLVED:] Sorting worksheets alphabetically
  7. Sleeper: return the source of the input of a combobox
  8. [SOLVED:] Create new directory for today's date
  9. [SOLVED:] Passing Sub Name as argument
  10. [SOLVED:] Copy selected columns to new sheets.
  11. [SOLVED:] Background on Excel
  12. [SOLVED:] Macro to open Word and Start Mail Merge
  13. [SOLVED:] Suffixes for sub command
  14. [SOLVED:] How to call/run a macro from other workbook?
  15. [SOLVED:] Transpose
  16. Advice: Using a Cert for SSL
  17. Sleeper: Converting to PDF
  18. Solved: "This File was created in a later version"
  19. Sleeper: Copying UserForm under VBA Control
  20. Sleeper: Copy Ranges from many sheets to one
  21. Sleeper: Inserting into a named range
  22. Sleeper: Sorting Data
  23. Sleeper: VBA Filtering
  24. [SOLVED:] Compute Date
  25. Sleeper: Password protect VBA Project in Script
  26. [SOLVED:] Correct syntax for Worksheetfunction.vlookup?
  27. Sleeper: Delete row when condition is true
  28. [SOLVED:] Stoping a workbook from opening when macros are disabled?
  29. [SOLVED:] LastModified = 5 minutes (???)
  30. Solved: Convert Cell to Hyperlink
  31. [SOLVED:] Inputbox search on specify sheets
  32. [SOLVED:] Can you sell a VB coded Excel spreadsheet?
  33. Sleeper: Change excel icon
  34. [SOLVED:] Minimizing UserForms
  35. [SOLVED:] Testers Wanted
  36. [SOLVED:] Keeping Formulas after edit
  37. [SOLVED:] Printing a series of records
  38. [SOLVED:] Copy Unique records to another location
  39. [SOLVED:] Line graphs in Excel
  40. Sleeper: Help with Renaming Excel Files & Toolbars..
  41. [SOLVED:] Variants as Array
  42. [SOLVED:] Printing Suggestions
  43. [SOLVED:] Assistance required
  44. [SOLVED:] Difficult one!!!
  45. Sleeper: Email Code issue
  46. Sleeper: The two lines problem
  47. [SOLVED:] Sheet continuation
  48. Sleeper: Possible to search Excel columns?
  49. Solved: Closing an Excel Workbook without "Save" Prompt
  50. Sleeper: Enable Auto Filter
  51. [SOLVED:] Weekday formatting
  52. [SOLVED:] interesting question
  53. [SOLVED:] Array Average not working right..
  54. [SOLVED:] Solved: Keeping formulas
  55. Sleeper: Image following Scroll Bar movements
  56. Sleeper: Listbox
  57. Sleeper: Error in built-in dialog xlDialogPrinterSetup
  58. [SOLVED:] Protection for Excel Sheet
  59. [SOLVED:] Moving from sheet to sheet
  60. [SOLVED:] Countdown inside a cell with a 1 second delay
  61. [SOLVED:] add a sheet (actually one already created)
  62. [SOLVED:] Help VBA alternative to DGET
  63. Sleeper: Tempremental coding?
  64. [SOLVED:] Easy code
  65. Sleeper: For review
  66. Sleeper: FileCopy not helping
  67. [SOLVED:] Paste to specific cell resulting from formula
  68. [SOLVED:] Array Formula to Compare Columns and Return Unique Entries
  69. Sleeper: SendKeys Issue
  70. [SOLVED:] On Error Help
  71. Sleeper: Follow-Up Timesheet Query
  72. [SOLVED:] Single line array/loop???
  73. [SOLVED:] Code returning error '1004'
  74. [SOLVED:] Copy active sheet & Clear unlocked cells on new sheet
  75. [SOLVED:] Populating a Combobox according to cell values
  76. Sleeper: Ask for a password before filtering
  77. [SOLVED:] What is the maximum length for a procedure
  78. [SOLVED:] Max no. of worksheets
  79. Sleeper: Merge Excel data to Word document
  80. [SOLVED:] Can't figure it out
  81. Sleeper: Querytables.add with multiple request (range get confused)
  82. [SOLVED:] Excel 97 - want to automatically move data
  83. [SOLVED:] I want to create a Macro That will save
  84. [SOLVED:] vba to copy selection of csv file to Workbook
  85. [SOLVED:] Simple IF with Worksheet Change Event
  86. [SOLVED:] Formula to change text colour and add a value to another cell
  87. [SOLVED:] Sleeper: Help with code to hide row
  88. Sleeper: OnKey Not Working
  89. [SOLVED:] add a existing worksheet to a workbook
  90. [SOLVED:] VBA 101
  91. [SOLVED:] How do I have VBA send an email to multiple recipients
  92. [SOLVED:] Excel workbook activation
  93. [SOLVED:] Auto Re-sizing Textboxes
  94. [SOLVED:] Disabling Reviewing Toolbar
  95. [SOLVED:] Hiding columns with a checkbox toggle
  96. [SOLVED:] Can these instructions be consolidated?
  97. [SOLVED:] My workbook stopped recalculating!
  98. [SOLVED:] page break code
  99. [SOLVED:] Cannot switch between Userform to Excel Workbook
  100. [SOLVED:] defining and handling of parameters
  101. [SOLVED:] Immediate Window statements
  102. [SOLVED:] Having some trouble with the find function
  103. [SOLVED:] Transfer paragraph(s)
  104. [SOLVED:] I need help with the file path script
  105. [SOLVED:] On Error ...
  106. Updating shared workbook
  107. [SOLVED:] Trapping Group/Ungroup Event
  108. [SOLVED:] Find the code behind
  109. [SOLVED:] Textboxes - more problems
  110. Sleeper: How to call or execute a program from excel Vba editors?
  111. Help with a mailmerge list
  112. [SOLVED:] Protect method
  113. [SOLVED:] How do I select more than one sheet and send as workbook
  114. [SOLVED:] Need a procedure to clear styles.
  115. Sleeper: Changing the order of the data columns
  116. [SOLVED:] Save Active Worksheet - Sever All Links
  117. [SOLVED:] Selecting Word reference library
  118. [SOLVED:] This works but I know it can be written better
  119. [SOLVED:] Reversed P in Excel
  120. [SOLVED:] Save wookbook as now() function
  121. [SOLVED:] Change to a Specified Range
  122. Solved: Need to know how to Unprotect all sheets at once with a macro
  123. Solved: Where have all the add-ins gone?
  124. [SOLVED:] How to Rename a VBA Module
  125. [SOLVED:] Stop if one of three conditions are true
  126. [SOLVED:] Workbook protection with an exception
  127. [SOLVED:] How do I insert a formula
  128. [SOLVED:] Combo box
  129. [SOLVED:] Merge cells with alive data & seprators
  130. [SOLVED:] Having a list without a userform
  131. Sleeper: Copying Data between Workbooks
  132. Sleeper: Find all macros used
  133. [SOLVED:] Importing content
  134. [SOLVED:] Looping Question
  135. [SOLVED:] Querrytable refresh
  136. [SOLVED:] When does Exit Sub not Exit Sub?
  137. [SOLVED:] Left Overs
  138. [SOLVED:] change font colour in a row according to cell value
  139. [SOLVED:] Copy from Excel to Word
  140. [SOLVED:] Write a Macro to Modify a Macro
  141. Solved: Using for next loop
  142. [SOLVED:] Lookup value in seperate workbook
  143. [SOLVED:] Find next available empty cell/row
  144. [SOLVED:] What Is VB IDE?
  145. [SOLVED:] Filling missing data from a table based on criteria
  146. [SOLVED:] Which is faster?
  147. [SOLVED:] Simplify and automate
  148. [SOLVED:] Email Priority
  149. [SOLVED:] Lookup and update between two workbooks
  150. [SOLVED:] Add macro to menu items
  151. [SOLVED:] Dynamic Data Exchange Code
  152. [SOLVED:] Add worksheet
  153. [SOLVED:] IF Statement in EXCEL
  154. [SOLVED:] Hide Excel application and show just a Userform
  155. Sleeper: Delete rows in mailmerge data source
  156. Sleeper: Move to different cell based on selection
  157. [SOLVED:] Length of text within cells
  158. [SOLVED:] Where to get Activex calendar control?
  159. [SOLVED:] What is wrong here.
  160. Sleeper: Find and replace txtbox in toolbar
  161. [SOLVED:] Write to PDF
  162. [SOLVED:] Different areas to be unpdated by different usergroups
  163. Solved: Push Values to Bookmarks in Word
  164. [SOLVED:] All possible ouputs of TypeName(Selection)?
  165. [SOLVED:] How to Format Comment Connector Line
  166. [SOLVED:] Detecting the Interior Color of a Cell
  167. [SOLVED:] Solved: Find function
  168. Sleeper: Combining event handler and Activex control formatting
  169. [SOLVED:] Copy Rows to Another Sheet Macro
  170. Sleeper: Find and Open Files
  171. [SOLVED:] Preceed or Append data to the selected cell(s)
  172. Sleeper: Change login path for distributing other loggers
  173. [SOLVED:] How to Copy VBA Help Examples to Editor
  174. [SOLVED:] Relieve Reptitive Stress
  175. [SOLVED:] Conditional hiding of rows with multiple Ifs
  176. [SOLVED:] IF statements using DATE values
  177. File size too big
  178. Sleeper: Copy and paste in userform textbox
  179. [SOLVED:] Kill/Close that open file
  180. Sleeper: Text Formulas, Macros, Cleaner Tools
  181. [SOLVED:] Prevent automatic updating
  182. [SOLVED:] An alternative to sheet protection
  183. [SOLVED:] Automate Menu Options Insert - Name - Define
  184. [SOLVED:] Conditional Format for ISBLANK
  185. [SOLVED:] Uploading a spreadsheet for assistance
  186. Sleeper: Check IF Process Running
  187. Sleeper: Formulas not working
  188. Sleeper: Suppress default drag&drop?
  189. [SOLVED:] Message box if number sequence matches
  190. [SOLVED:] Set rng as Multiple Ranges
  191. [SOLVED:] Finding all ranges EXCEPT those with color fill
  192. [SOLVED:] Unable to add data to List and Comboboxes
  193. [SOLVED:] Compile Error
  194. [SOLVED:] Self define function shows error
  195. Sleeper: Show Code Pane in Main Window
  196. [SOLVED:] Get Weight of border of top left cell of a range
  197. [SOLVED:] Unhide a paticular sheet
  198. [SOLVED:] I need a shortcut (because my method requires too much typing!)
  199. Sleeper: Simple database userforms
  200. [SOLVED:] Transfer data between sheets
  201. [SOLVED:] Quick & Easy-
  202. [SOLVED:] Is There a "Find" for the VBA Macro List?
  203. [SOLVED:] Command button and a recorded macro
  204. Sleeper: Real N00B help about free cells
  205. [SOLVED:] Loop through sheet
  206. [SOLVED:] Tables everywhere
  207. [SOLVED:] Totaling a column that changes length with blank cells
  208. [SOLVED:] Copy sheets from one workbook to another
  209. [SOLVED:] Recognizing column name
  210. [SOLVED:] Help with Unlocking a locked worksheet and breaking Links
  211. [SOLVED:] Build Word Table From Excel Spreadsheet
  212. [SOLVED:] Copying data from first worksheet and populating other sheets
  213. [SOLVED:] What Does This VBA Syntax Mean?
  214. [SOLVED:] Define name for a dynamic list
  215. Advice: Creating a licensing method
  216. [SOLVED:] Getting the Name of Executing Macro
  217. [SOLVED:] Getting the Name of the Calling Macro
  218. [SOLVED:] Problem with an awfull lot off checkboxes
  219. [SOLVED:] "Ambiguous Name Detected" Problem
  220. [SOLVED:] Setting .SubTotal TotalList via VBA
  221. [SOLVED:] problem with changing colour
  222. Solved: auto open password protected excel file
  223. Sleeper: Increment Lines in a formula
  224. [SOLVED:] Open a workbook without knowing it's name.
  225. [SOLVED:] Create drop down menu in toolbar
  226. [SOLVED:] Conflict Protect and WS_Calculation
  227. [SOLVED:] Date problem
  228. [SOLVED:] Need help with a Formula
  229. [SOLVED:] Positioning an AutoShape on the Worksheet
  230. [SOLVED:] Greenbar Look Report
  231. [SOLVED:] "File In Use" problem
  232. Sleeper: Range
  233. [SOLVED:] Userform ListBox
  234. [SOLVED:] Subtraction formula help
  235. [SOLVED:] Macros to add rows and subtotals
  236. [SOLVED:] Invalid Reference (Macro)
  237. [SOLVED:] combining worksheets macro
  238. [SOLVED:] Filling in Empty Rows with whats in the row above --HELP
  239. [SOLVED:] Conditional hiding of rows Part II
  240. [SOLVED:] Performing a cell-specific action in a "do until" loop
  241. [SOLVED:] How Does the RGB (Color) Fctn Work?
  242. [SOLVED:] Save xls Sheet as txt file
  243. [SOLVED:] XL 2003 Calendar Control Problem
  244. [SOLVED:] Copying Formulas
  245. Sleeper: Personal.xls macros "not available"
  246. [SOLVED:] Case Statements- General Question
  247. [SOLVED:] Accessing multiple files for 1 report
  248. [SOLVED:] Nested IF formula question
  249. [SOLVED:] Sort sheets
  250. [SOLVED:] Create Excel addin