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