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. Standard open/save file forms in VBA
  2. Cannot delete SendTo or My Docs folder with DeleteFolder
  3. Move sheets to a password protected closed workbook
  4. Auto Run Macro
  5. Using 1 file to create 2.
  6. Hi I have a workbook with sheets named from A to Z. These sheets suport a smalboboxes
  7. [SOLVED:] Drop List for a column...
  8. HELP with Removing Styles: error029120_01.xml
  9. [SOLVED:] How to Reference Sheet Name in Formula
  10. Solved: How incorporate an OR( into a MAX(IF( function?
  11. Solved: MsgBox to ensure proper values are used
  12. function
  13. Filter in Excel
  14. Copying a Textbox and Combobox at runtime
  15. [SOLVED:] Why Is my code so painfully slow?
  16. Syntax on Application.Average
  17. Formating Subtotals
  18. Solved: ListBox as a Variable?
  19. Sort Alphanumeric Data & Retaining Leading Zeros
  20. Paste Multiple lines into single Cell
  21. [SOLVED:] Excel userform ListBox multicolumn
  22. Solved: worksheet scrolling
  23. Solved: copy range issue
  24. Filtering data with userform
  25. error when changing data in a Pivot table usinga macro
  26. right click menu
  27. excel date activated self destruct
  28. Solved: code to turn on update links
  29. Solved: vlookup with condition
  30. Automate Lagging of Variables
  31. folders and subfolders troubles
  32. Solved: Rearrange the location in txt file by EXcel VBA
  33. Formating Data
  34. Error 438 FileDialog Filters.Add
  35. Problem Importing Files
  36. Disable or enable
  37. Manipulate the Ribbon from VBA directly
  38. Getting the integer of the month
  39. Solved: Application-defined or object-defined error
  40. Click on cell to open item for editing
  41. adding code to a sheet that is added at runtime
  42. open xlsm vs. xls
  43. Multiple Column Listbox help
  44. Dealing with #N/A and non-continuous sums
  45. Solved: New to VBA
  46. Solved: macro to edit/format data in excel 2007
  47. Solved: Userform - Code as written will not populate all 22 data elements
  48. [SOLVED:] Using Ampersand "Showing a Zero"
  49. vlookup macro tricky
  50. Sorting items in a multi-column listbox
  51. Solved: Macro for finding rows and copying to a new sheet.
  52. Solved: VBA Sources
  53. Solved: Parse cell data into seperate columns
  54. Response Time UDF needs to be modified
  55. Solved: Chart Format
  56. iexplorer macro
  57. screen redraw problem (not ScreenUpdating)
  58. Error Copying Data
  59. Solved: Yield to Maturity
  60. Excel VBA code to get Autofiltered data to array
  61. macro to speed up deleting empty rows process
  62. Solved: if formula
  63. Solved: I want to set column H to column V as the email body
  64. Solved: formatt numbers macro
  65. Solved: remove/delete empty rows
  66. Vba Code Error
  67. 1004 / Out of memory
  68. Solved: Copy Paste Loop Multiple Sheets
  69. Opening and saving an email attachment from outlook
  70. Insert row after data change
  71. Solved: if formula
  72. [SOLVED:] creating subfolders and saving files in them
  73. Solved: macro to delete rows
  74. Solved: remove/delete cells
  75. Drawing Borders in VBA
  76. Solved: event to capture changing the height or width of a cell
  77. [SOLVED:] Counting cells in one column based on values in a different column.
  78. Solved: default program for a file type
  79. Solved: Forms - creating a wizard with moving parts
  80. Help with Function in 2003 conversion to 2007
  81. moving data to another tab in Excel
  82. delete all #n/a
  83. Solved: Variable as AutoFilter Criteria
  84. Solved: Copy information in named range to another workbook
  85. How do I Drag and Drop to a Userform Control?
  86. vba and scripting
  87. macro to edit data in worksheet
  88. Solved: What did Mr. Gates do to me now?
  89. Solved: Insert new data in first row
  90. Pulling data from between apostrophes ?
  91. decision tree
  92. Macro Help
  93. filtering
  94. Solved: Text from mutliline txtbox to merged cell
  95. Passing Values::Arrays
  96. Utilising Range
  97. Draw line between data points on excel chart
  98. Solved: copy sheet to a different workbook
  99. Checking for DOS executions
  100. copy a module from one workbook to another via code
  101. Selecting 1 column data from Multicolumn-Combobox
  102. Change TextBox To ComboBox
  103. Losing control once I press a web page button. HELP!
  104. Transferring data from one Userform to the next
  105. Solved: Copy range when its not zero
  106. Files getting inexplicably bigger!
  107. Solved: Matching up columns of data
  108. Get Formula
  109. macro assistance -
  110. Solved: Calling the Solver from VBA
  111. Solved: Create New Record in Access from Excel Macro
  112. Solved: AutoFill VBA is not working with my formula :S
  113. Solved: Really Stupid Question
  114. AutoFilter Problem
  115. tips and techniques on how to properly design your vba for distribution
  116. Solved: macro to copy data - down other columns
  117. add picture
  118. Solved: Why is this line failing on me?
  119. Solved: auto descending order using macro
  120. Holding the formatting on a table from a website
  121. Solved: Function to return Date based on Current Date + number of Days?
  122. Window Activate Anomoly
  123. big problem xls file
  124. Solved: Updating named ranges between two versions of the same file
  125. Edit Personal.xls via Macro
  126. Print records after filtering in mail merge from excel to word
  127. Manipulate VBE Window
  128. Solved: Insert name and auto save as... macro help
  129. Solved: Triangulation help needed.
  130. Preview Groupwise Draft Messages before sending
  131. Set Field Tab Order
  132. Solved: Find Out what Page a cell will print on
  133. Solved: How do you find first Cell
  134. add 4 formula to current macro
  135. Solved: Change a reference in a formula as you drag the formula from cell to cell
  136. Solved: Remove characters from text function
  137. [SLEEPER:] Referencing drop down menu in worksheet
  138. Solved: Format Date data
  139. UserForm & Macros from Office 2003 to Office 2007 causes errors. Any ideas?
  140. Solved: Help with VBA Code
  141. Dynamic chart with VBA
  142. data base user form question
  143. clear format problem
  144. CHART Challenge: Plot NA# as null values
  145. Marco for print outs
  146. Solved: Hiding sheets
  147. Solved: Change Password on Multiple Files in a Folder
  148. Solved: Type Mismatch?
  149. [SLEEPER:] Running a Macro in one workbook from another workbook
  150. Dim Array() As Workbook??
  151. Solved: Find in VBA
  152. Solved: Extract file names & h-link, combine codes
  153. Solved: change text in multiple cells with VBA
  154. Solved: workbook referencing another workbook
  155. Solved: Setting Cell Value = #N/A
  156. Type Mismatch
  157. Check if Visual Basic Editor is open
  158. finding any coloured cell
  159. Solved: named range issue
  160. Solved: creating desktop shortcuts
  161. Solver Error: Set Cell must be a single cell on the active sheet
  162. Solved: Sum Corresponding cell from different worksheet
  163. Solved: Transferring data
  164. Sorting Numbers-as-Text with Data|Sort + AutoFilters
  165. Solved: Problems with finding last column
  166. Solved: import from text, run VBA, all in one shot?
  167. Solved: Application.Max(rng)
  168. Solved: Matched
  169. Solved: Adjusting If-Then statement in code
  170. Solved: Equivalent Range on specific row
  171. Solved: Setting CommandButton = False under a specific condition
  172. Open PDF (via VBA) on specific page
  173. Auto Reply Notification
  174. Solved: Sum Crazy, sum columns with variable headers
  175. I need help cleaning up this code.
  176. Solved: Replace Cell with Formula - automatically
  177. Solved: Importing Email from Outlook to Excel
  178. Solved: HELP - Multiple User Worksheet - Code Amend
  179. Macros in dropdown menu in Menubar
  180. How to speed up cut and paste macro code (12-16-09)
  181. Solved: Copying & pasting multiple columns using VBA
  182. Listbox Row Source
  183. Solved: Hide worksheets file close
  184. Solved: Copy a workbook
  185. Autocomplete
  186. [SOLVED:] Too Many Different Cell Formats
  187. Checking conditions to determine what commandbuttons should be enabled
  188. Solved: Copy from one sheet to multiple
  189. Ribbon Addin not closing when Main Addin closes
  190. Solved: Copy rows with todays dates
  191. [SOLVED:] Delete rows based on specific data
  192. Solved: Is it possible to have a function return an array of ranges?
  193. Only ONE checkbox is available
  194. delete rows based on two columns
  195. Solved: Replace specified characters with a number
  196. edit pic code not working
  197. Insert SharePoint Content controls in Excel 2007
  198. Plotting two series togheter
  199. Solved: Chart with multiple x-axis labels
  200. Solved: Converting rows to columns
  201. [SLEEPER:] Heading Format from excel to word
  202. Solved: error handling error
  203. Setting worksheet name equal to variable value
  204. Solved: Help writing excel spradsheet to txt
  205. Excel VBA Internet Explorer Java Automation
  206. Set chart line termination with VBA code in excel 2007
  207. Add DropDownLines
  208. folder to folder copy using vba with conditions
  209. VBA Vlookup with a complicated path...
  210. Keep Validation Input Message on screen when first open workbook (12-20-09)
  211. excel copy
  212. Solved: Lock cells based on cell value
  213. Solved: simplify the sintax for case + if
  214. Solved: Update a COUNTA cell in a pivot table
  215. Input-form for records
  216. [SOLVED:] ScrollBar to show Userform Form field values
  217. Solved: VBA Return to Initial Selected Cell
  218. How to export part of a sheet
  219. Solved: open a text file with complex macro in current workbook
  220. Taking links from a site direct to a textbox
  221. [SOLVED:] Interaction between applications
  222. Date display issues in Consolidation File
  223. ListBox Headers and Sorting
  224. Reference groups of excel data
  225. Solved: Formula question for extracting numbers
  226. text file
  227. Solved: Keep cell in edit mode after VBA paste
  228. Direct Connect to mysql
  229. See only relevant data based on user and password login
  230. Excel VBA to cut & paste between worksheets
  231. Solved: UDF problem with ADO query
  232. Solved: Add to existing comments via Userform
  233. Paste value from combobox into cell
  234. Security Alert
  235. Solved: Why doesnt this work? I need someone smart!
  236. Built a Hyperlink in excel using micro
  237. To find the unknown parameters by using subroutine
  238. Solved: sending data from form to doc
  239. Simple UDF....or so I thought.
  240. PRINT MACRO
  241. Solved: Analysis Toolpak
  242. Solved: Right click menu in excel 2007
  243. Solved: MouseWheel Event
  244. Solved: Memory used
  245. Solved: Format numbers
  246. Solved: Another format numeber issue
  247. conditional drop down list box
  248. Solved: For, Each, Next Loop with a Skip
  249. Excel macro enabled workbook is not working on Vista m/c
  250. Show shapes when the pointer move over on any range