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

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