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

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