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. Solved: pivot tables
  2. read only
  3. Solved: Questions about calling procedures to shorten code
  4. How to Format a TextBox bound to a ControlSource?
  5. Solved: Copying worksheet formula results to a new workbook.
  6. Recommend Books for VBA, Excel, and Access.
  7. Solved: erase blanks
  8. Solved: Macro to close all windows but one
  9. need help with coding
  10. Web Toolbar
  11. Quick Subtotal Question
  12. Solved: Pivot table (XLD)
  13. Solved: Copy cell range, paste into Outlook Contact Notes
  14. Coding alternating blank lines w emails
  15. Solved: Retrieve Outlook Contact Data
  16. Solved: SumProduct
  17. Solved: fso.GetFile not working!
  18. Solved: Default file
  19. Solved: worksheet buttons
  20. Solved: Shape colour
  21. Calender Control
  22. how to eliminate Ist column
  23. Hide 2 of 3 Pivot Chart Buttons?
  24. match variable with list
  25. VBA Excel Project
  26. Solved: Generating Unique Number ID's
  27. Solved: Chart. Very different value. SpinButton
  28. manipulating userform objects from a code module
  29. Solved: Adding to values together within a cell programatically
  30. Solved: Vlookup Question
  31. Solved: Sumproduct problem in table
  32. Solved: How to capture cell changes
  33. Solved: SUMIF "CELL IS NOT NULL"
  34. Solved: Hello all, a little help needed if possible...
  35. why i am having run time error with this code
  36. Solved: Copy worksheer to all workbooks in specified folder
  37. How to group all sheets by default
  38. Solved: Find text & Mark findings
  39. Paste into a comment box directly from clipboard?
  40. Solved: Passing a module as a parameter
  41. Select and copy every second row
  42. Solved: Move rows to new work book based on a cell value.
  43. Solved: Protecting Custom Properties
  44. Solved: Formula for Conditional Formatting
  45. Compare and delele cells with equal value
  46. Solved: How do I activate an Outlook dialog box, make selection, then return to Excel?
  47. Solved: CAPS LOCK Balloon Message
  48. Solved: User name
  49. Adding Continuous Check Boxes
  50. pivot tables
  51. Converting XLS file into CSV file
  52. Solved: Find row number and pass it to a variable
  53. vba excel code to find current dll running
  54. Create a single .csv from multiple worksheets
  55. Solved: Trying to compare two columns
  56. Solved: printing worksheet
  57. Solved: Sorting Cells with Empty Strings
  58. File Save User Form
  59. Solved: save combobox selection to worksheet
  60. DisableAutoMacros when opening Word in Excel VBA
  61. VBA coding to run macro on multiple files
  62. Solved: Call a Userform when "Esc" key is press
  63. ok
  64. Retreiving tab name
  65. Solved: Applying a countif formula to each section of data in excel worksheet
  66. VBA Coding for function that has multiple Integer Value
  67. Alternative To ActiveCell.Row
  68. Solved: using outlook dialog boxes in excel
  69. Shopping Basket Analysis
  70. Copy a file
  71. Solved: No warning when overwriting file
  72. scheduling a macro a once a week
  73. How many characters can countif handle?
  74. date format and filtering
  75. Solved: How to resolve out of subscript range error?
  76. XLS size restriction?
  77. Solved: Writing UserForm data to a Specific cell
  78. Remove Tool Bar in Chart Sheet
  79. Right mouse click on user form
  80. Finding VBA and Function code
  81. Cell Contains Word
  82. Solved: Userform/sheet selection
  83. Need help deciphering code
  84. Use of File Array in Excel VBA
  85. Solved: Code to find match & remove data from 5 sheets
  86. How to identify workbook?s name?
  87. Solved: Alter code to only copy values without formulas
  88. Solved: vba code for adding same row next column if condition met
  89. Solved: wildcards for not contain
  90. Solved: adding a Month
  91. Working With Multiple Workbooks
  92. UserForm
  93. limited period
  94. pasting range .offset
  95. Solved: for loop
  96. Solved: Save dates for weekly figures
  97. Between --- in excel?
  98. Solved: Use Command button to e-mail from userform
  99. Solved: Change Data for Chart via dropdown
  100. Userform/sheet selection again
  101. Problems running macro from another workbook
  102. VBA - Changing SeriesCollection.Values for Line Chart
  103. Import data
  104. VBA Set PivotItem to Not Visible
  105. Solved: Quit Application if filename is renamed
  106. Solved: Combining macros to open and run on multiple protected worksheets
  107. Moving an Entire Line using ActiveCell.Row
  108. Dragging Listbox Items within same listbox up/down
  109. Prevent Save, enable SaveAs with default file name
  110. Solved: VBA for Concatenate
  111. VBA: Insert cells without affecting formulas
  112. Solved: Adding only certain values within a cell
  113. Solved: Extracting Data Based on Date Range
  114. Solved: Turning an m*n matrices into m*n rows
  115. add multiple array to combobx
  116. Macro to open workbook read only
  117. Solved: Passing a variable
  118. Solved: Error With Code (Compile Error) ~Excel 97~
  119. Please help with the simple loop
  120. Solved: N Dimension Arrays
  121. VBA Web query newbie problem
  122. Transfer Listbox Rowsource to Worksheet Range
  123. Addin wants password when exiting Excel
  124. export excel to outlook
  125. Dealing with worksheet insert error
  126. Exit sub issues
  127. Passing variable to UserForm textbox effort
  128. Solved: date and time score as text
  129. Macro fills in blank cells with formula stops at endrow
  130. Solved: referencing a sheet and cell
  131. Solved: Alter code to clear contents not delete row.
  132. Solved: VBA function to return hyperlink
  133. Solved: Userform combobox macro to make autosort
  134. Code to delete all modules
  135. Excel-Access Question
  136. Consolidating multiple series in worksheet by Date field
  137. Auto compress pictures
  138. align email body from excel
  139. Macro not pasting to correct place
  140. Managing large numbers of buttons
  141. Filter validation list
  142. Urgent - aligning text to the right
  143. Sharing a Variable
  144. Need help with Button command
  145. Align a picture in the center of the screen using VBA
  146. Excel Custom Properties
  147. Calculating Averages
  148. Solved: need help with command button
  149. Any workaround for assigning values to multiple cells by excel formula or function
  150. charts and data table
  151. Solved: count rows excluding header row
  152. Solved: scrollbar.width property problem on other computers
  153. Macro stops when criteria not met
  154. Template and SaveAsUI
  155. Solved: Button Command Challenging
  156. Create Summary Sheet then export that to a Master Workbook
  157. Update a cell with another cell
  158. Excel 2007 Removing a Custom Tab and Ribbon
  159. Trouble with vlookup
  160. Solved: assigning values to variable using loops
  161. Quick question about Application.GetOpenFilename()
  162. Solved: Workbook Event CODE
  163. Notepad to xls
  164. Workbook_BeforeClose and Workbook_Deactivate
  165. Provide option to disable macros
  166. Vlookup help
  167. Copy & Paste
  168. Scripting dictionary
  169. Solved: Creating a data tree in the worksheet
  170. Solved: Changing the printer designation for each user
  171. Copy data from one workbook to another!
  172. How do I change ?i? as an integer (ie 1,2,3,4?) to ?i? (1-10) with intervals of 0.1?
  173. Solved: Blanks and bad characters
  174. Solved: Paste on grouped sheets in VB for Excel
  175. Macro to Protect formula cells
  176. array sum
  177. Solved: password recover?
  178. Get all cells in a column
  179. usinig netdays in an "if then" code
  180. Solved: Download with UserForm
  181. Solved: Error when referencing 3 ranges with a variable
  182. Default Value in Combobox
  183. Sumproduct help
  184. help with code for conditional summary sheet
  185. Solved: Close workbook
  186. Solved: Excel in-formula macro help!
  187. Solved: Excel Pasting doesn't align to Word Bookmark
  188. Moving Charts in Excel Worksheet
  189. Range that increments column number
  190. Solved: Computing Average Using Offset
  191. intra portfolio correlation formula in vba
  192. Close Workbook and Show Userform
  193. Solved: VBA to delete all "unused" formulas
  194. Building a data base from Real-Time Data
  195. Return text in cell based on match of multiple criteria
  196. Solved: Import HTML Query Named range issue
  197. Named Ranges
  198. Solved: Saving worksheets as separate workbooks
  199. Double Click
  200. Create an access database by a VBA in Excel
  201. Solved: chart sheet and work sheet
  202. Solved: Problem initializing Class after adding an ActiveX control
  203. Solved: Date Format in UserForm
  204. Solved: Excel data to Word bookmarks
  205. Solved: Help please...input box issue...
  206. Error handler not working
  207. Data Range Issue
  208. Inserting default character(s) when submit button is pressed
  209. Wont let me select range
  210. Runtime error while using Advanced filter
  211. Solved: How the Code Works?
  212. Paste Named Range
  213. Solved: Code to check that a worksheet name from an inputbox is valid?
  214. How to make this VBA better
  215. Solved: Pop up errors/boxes when running macro
  216. Understanding Multi Column Listbox
  217. get particular data from outlook mail into excel using VBA
  218. Creating a macro to copy formulas
  219. Install addin for everyone
  220. Solved: Assistance With a ComboBox
  221. Deleting rows, adding columns and Excel formulas
  222. Soooo Sloooow!
  223. Context specific help (WhatsThisHelp)
  224. Solved: Fastest way to divide all rows in column C by a fixed number, put results in column D
  225. Getting Unique elements of Array
  226. generate matrix from table?
  227. Solved: VBE to change Line Chart Height based on number of Rows
  228. Building a hierarchy
  229. how to get the language installation
  230. Solved: Do I need SUMIF for this problem?
  231. Solved: password to modify
  232. Solved: Moving Copying and Deleting A Sheet
  233. Summing all rows in a column in a specified worksheet
  234. Highlighting filtered columns - automatically
  235. Solved: Update Recordset from VBA Not Working
  236. Solved: Do loop problem is last row (65536) reached
  237. Solved: end if without block if?
  238. Solved: Macro won't loop to second worksheet
  239. Solved: How can I test a Form Label to see if it is contained in a given Form Frame?
  240. Solved: Cut a Long list in half and paste into a new Column
  241. Solved: Data Validation: Drop-Down Text Size
  242. Solved: Macro to find code in many columns and copy findings (not easy)
  243. Pasting Special Cell into different sheet
  244. Solved: Solved....Locking Cells?
  245. Help button to open pdf or chm
  246. IE Automation form Javascript
  247. Custom Pivot Table Drilldowns in Excel 2007
  248. Run code on workbook open
  249. Tab Order
  250. dictionary userform