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

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