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