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

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