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. [SOLVED:] Copy Selected Rows to Chosen Sheet
  2. Solved: Date Time Picker
  3. Solved: Determine Variables and Values
  4. Using Lists in a Chart Series Formula
  5. Making an Excel sheet that fills webforms - new guy to VBA.
  6. Data Interpolation
  7. links
  8. add template as new sheet
  9. A macro for emailing a workbook
  10. Creating a dynamic chart
  11. Protect CommandBar Menu Item or Prevent use of VBE Menu during an Excel Session
  12. Solved: Message box question
  13. format a msgbox
  14. Solved: Search multiple sheets and copy results to another sheet
  15. Solved: Split variable across mult-column listbox
  16. Solved: find matching cells btwn 2 lists and copy related records
  17. Solved: add template after activeSheet
  18. is this possible ? (product invioice)
  19. Importing a Module That I've Exported
  20. Solved: pivot table conditional format
  21. working with Time
  22. VBA code for text to column in 2002
  23. Solved: From Excel Macro - Access a Word Document
  24. ERROR in code
  25. [SOLVED:] Disappearing Macro Names
  26. Excel - VBA
  27. Text in a cell, and row AutoFit
  28. Solved: Regressively search worksheets - similar to VLOOKUP's
  29. Data format
  30. Solved: Sum a spreadsheet base on 2 criteria
  31. How to copy a few cells from each worksheet into a summary sheet?
  32. Solved: Trigger code from SQL Query refresh
  33. Solved: Sumproduct problem? Driving me mad!
  34. Solved: How do I run a macro a set number of times
  35. vlookup udf
  36. Do All Modules Get Loaded??
  37. Modifying VBE references causing problems in a class module?
  38. Solved: Use Textbox Values in Loop
  39. Formatting
  40. Mkt price close to Moving average
  41. Solved: Conditional Format
  42. MATRIX
  43. How to Get a Chart?s Next Available Series Number
  44. Help sorting and inserting rows
  45. Solved: Excel Addin AddInInstall()
  46. Solved: Add to Standard Toolbar
  47. Chart Point Label with Variable Info
  48. "Grey out" menu
  49. Solved: Program for combo box is overwriting formula in cell
  50. "Out of Stack Space" Error
  51. Dependent lists
  52. Switching Forms
  53. Solved: Min formula
  54. Solved: Convert week N to specific dates (mon to sun)
  55. Solved: Switching off background actions.
  56. Enabling Macros
  57. count conditional format
  58. Insert Sub Total at page break
  59. Solved: Search and Find
  60. Solved: Updating label caption
  61. conditional format color
  62. Calculating Correlations using VBA
  63. Manipulating timestamps
  64. xl Cell Properties
  65. Solved: Max or Large Function
  66. OWC10 ActiveX security Message
  67. Help needed: No Experience At All
  68. Solved: Calculating the Week Number Corresponding with a Specific Date
  69. Solved: Accidently selecting listbox entry on next Userform
  70. Dynamic Chart troubles
  71. Changing ListBox Range - From another ListBox
  72. Solved: Combining two cells in VBA
  73. How to test cells data type?
  74. COUNT IF
  75. COLOURED CELLS
  76. How to use Countif in VBA
  77. "obtain the colorindex from another cell"
  78. Solved: Recocnise ascending numbers with text
  79. Solved: Macro for countif
  80. Please see file this is what i am stuck on
  81. Solved: Looking for an easy way
  82. Conditional Formatting
  83. using a macro and time
  84. Recorded Macro Needs Altering
  85. excel & outlook express
  86. More than 3 conditional formats
  87. Solved: Problem: Coding search engine in Excel with VBA
  88. Conditional Formatting and re-evaluate
  89. vba to download files from internet
  90. Solved: Find Last used Column
  91. Solved: Checkbox madness
  92. Solved: Force use of macros/Enable trial period
  93. Solved: Columns show hide
  94. How to set no. of line per scroll for different worksheet
  95. save workbook titled with current date
  96. Solved: Code Help Needed
  97. Cover up password InputBox
  98. Solved: Green is the color for newbies: Man am I Green
  99. sum a table
  100. Solved: Data for Mail Merge to be consolidated
  101. selection.Sort error
  102. Solved: Find Last Row
  103. Solved: How to use Range Names in a correct way?
  104. Problem with VBA, not with VB 6.0
  105. Sleeper: Outputting information to a calendar
  106. Solved: Chart Help
  107. Too Many line continuations
  108. Sleeper: Locate and copy from database to another worksheet
  109. nonexisting array-element null value ?
  110. Solved: Listbox Value Writing to Form
  111. Solved: Date and Time Calculation
  112. Solved: Excel to Word
  113. Solved: Assign data to Combo Box
  114. Searching for a Chart Series by Series Name
  115. Solved: Timed Loops
  116. Solved: based on Cell/Column content ,cut 1 sheet's row values and paste it in other sheet?
  117. Sleeper: Inserting email address
  118. Help with printing macro - -please!!!
  119. VBA Codes that i like to learn :)
  120. [SOLVED:] Calling the "Duration" function in excel to be used in VBA?
  121. Solved: Copying sheets and incrementing names
  122. Solved: Inserting Rows
  123. Solved: Rearrange columns
  124. Displaying a graph on a form
  125. Explain this bit of code
  126. Date Difference but as Text Format from Form
  127. How to use SPLIT function in VBA
  128. Solved: Unusual Problem using mid and format in vba
  129. Input box error handling
  130. Shared File Utilizing Template
  131. Abstract summary data using formulae
  132. Rename sheets from cell in active sheet
  133. Call function
  134. IsMissing is not working!
  135. Ordering a listbox
  136. IsNumber is not working
  137. Solved: Diffrentiating same week numbers , but of different years.
  138. help with unusual date find
  139. Restore all built-in toolbars
  140. Save as causing change event on combo box
  141. run-time error '424'
  142. Solved: Using named shapes
  143. Controlling userform data with combobox.
  144. Autofilter optimization
  145. Solved: Look up a date range
  146. Solved: help with changing properties of objects on a form
  147. Fairly new to VBA, what training.....
  148. [SLEEPER:] Ways to remove items from combobox
  149. Solved: Help! - copy rows based on column criteria
  150. Problem between sheets
  151. Execute Conditional Formatting Code on TWO events
  152. Merge 2 Named Ranges
  153. Characteristics of an Invisible Sheet
  154. Solved: Copy between sheets
  155. Sleeper: Using loop Macros
  156. Solved: Row question
  157. Solved: writing option button caption in a cell
  158. Solved: Progress Bar
  159. maro to work on one sheet as opposed to all sheets in the workbook
  160. VBA Properties Locked
  161. text box search
  162. Solved: Equations using adjacent worksheets
  163. Where is UserForm_Initialize() ?
  164. [SOLVED:] Application.Calculation
  165. Conditional copy for row-Date range
  166. Solved: Send a frame control to a procedure as a parameter
  167. Solved: copy and transfer specific rows
  168. Solved: Calculate time
  169. Solved: Getting value from interception of row and column.
  170. Solved: Save on exit to a folder
  171. Excel vba syntax for Access query
  172. Pivottable Refresh
  173. [SOLVED:] List All Macro Shortcut Keys...
  174. Lookup using VBA
  175. Solved: Create New Collection
  176. Solved: Insert Deleted Cell At Bottom Of Range
  177. Solved: Check if Named Range exists
  178. Solved: Copy update value from changing file name
  179. Solved: Moving to a specific cell with VBA
  180. Solved: Drive letters for Devices with Removable Storage
  181. Userform - Column Heads
  182. Solved: Unprotect/Protect Workbook
  183. Formatting a number
  184. Solved: Insert Rows by taking the difference from another worksheet.
  185. Copy a row, delete, then move on
  186. Solved: Intercept Late Binding (Double Click xl file)
  187. Solved: Sum all cells using Sheet Name, Row number, & Column number
  188. Solved: Sort Non-Adjacent Columns
  189. Merging cells and suppress excel's popup
  190. Solved: Rewrite this line of code
  191. put range of cells into variable
  192. dates between dates???
  193. Solved: For Each c In Range("Test")
  194. Where Are the Hidden AutoShapes??
  195. summing months
  196. Solved: MDI "like" child userforms ?
  197. Solved: Copy specific rows
  198. Solved: do - until cell equals blank
  199. Solved: Can't use Right function???
  200. Populate empty cells with zeroes?
  201. Solved: select other object when a textbox is full
  202. Match & Index Functions
  203. Solved: Select Rows by Date
  204. Solved: Problem with indexing on a user form
  205. Format a cell before writing in it
  206. Solved: Finding a range based off of two comboboxes
  207. Solved: Excel macro question: matching text to numeral value & inserting the numerals + more!
  208. Inserting Values in a Multidimensional Array from Two Different Controls
  209. Solved: Help: Adding function to line of code
  210. Help on code found here (InputBox Type 8)
  211. multiselect list box
  212. Solved: How to Paste.Special.Values w/ this line of code
  213. Solved: Help understanding line of code
  214. Streamline code from MRecorder to Good Code Help
  215. Solved: how to buttom changed from inactive to active
  216. Can you ppl help me test this macro?
  217. Password Protection
  218. Scope of Two Defined Identical Names
  219. Copy worksheet information to Word using VBA in Microsoft Excel
  220. moving row of data from one sheet to another
  221. Solved: Disable "X" Button on ActiveWorkBook
  222. [SOLVED:] Reading Tag name, editing it and saving.
  223. Solved: how to display all options of a combo box
  224. Macro to Delete IF
  225. Switch to unknown named workbook
  226. Solved: Code is broken
  227. If this do that, If not Do the other
  228. Count Rows
  229. WordWrap and TextBoxes
  230. Solved: retrieve specified field data from other Excel file & append to current Excel file.
  231. Getting list of table & field names from Access into Excel using VBA
  232. pick up same artno but differnet attribute
  233. calling the internet
  234. Solved: Removing hyperlinks
  235. Solved: Convert formula to vba code
  236. Template-document new equivilant in Excel
  237. textbox autotab and maxlength properties
  238. Delete duplicates
  239. Solved: Setting a date range
  240. Solved: How to hide the Excel Icon in a custom menu bar
  241. Solved: If text then perform this, if not then skip.
  242. Solved: Making Excel invisible on opening
  243. Using a cell reference/column value to copy rows to a new worksheet
  244. Solved: Help with a Loop in a Loop
  245. Importing libraries explicitly in macro code
  246. Solved: Sum rows according to column condition
  247. deletea ll sheets
  248. Solved: Excel to get Data from an Access Database
  249. fifa 2006
  250. Solved: Active Workbook