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