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

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