PDA

View Full Version : Excel Programming

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 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309
  1. [SOLVED] setting background colour
  2. Run-time error '1004'
  3. Rounding up to desired decimal value
  4. How to Call the Esc key on Keyboard.
  5. Changing Private Macro into Conditional Formatting
  6. Excel 2007 bug or my copy only?
  7. [SOLVED] Getting values from list box
  8. [SOLVED] Problem with Conditional Formatting Macro
  9. Limit Pivot Items
  10. VBA for limiting number of similar entries with a pop up box
  11. [SOLVED] Delete Duplicate Rows, with a twist
  12. [SOLVED] Remove selected item from listbox
  13. Programmatically loading controls into UserForm toolbox
  14. font color equals interior color
  15. Storing distinct values
  16. How to create a macro to sort a .csv
  17. add-in menu fails to drop down on alt+letter
  18. userform textbox that searches column b
  19. [SOLVED] Mask search with *
  20. [SOLVED] VBA to change a particular cell
  21. Autofill Based On Integer
  22. Change font color (conditional)
  23. How to grab the current URL?
  24. Creating a list of tasks and their subtasks...
  25. Non-repeating numbers
  26. Seach and Copy Macro
  27. Migrated Code Error
  28. Solver - Showing all solutions
  29. Data Security - Replacing first four digits of a membership number macro.
  30. [SOLVED] Many If, Or statements in one formula
  31. Runtime error 91 - Object variable or with block variable not set
  32. Subscript out of range error
  33. [SOLVED] Automatic macro update
  34. formula for the Week of the quater
  35. LateBinding and "Type not found"
  36. delete some rows based on the data
  37. [SOLVED] Macro to autochange letters
  38. [SOLVED] Delete Row1
  39. if query in macro
  40. Open, Convert, Consolidate
  41. [SOLVED] Will Running a Macro Within Another Macro use variables?
  42. Assign Autofilter Results to a Range object
  43. Macro to display the extra names between 2 columns
  44. Finding location in Word works from Word but not from Excel
  45. [SOLVED] Match Function OK in worksheet but type mismatch in VBA
  46. [SOLVED] modify code to always centre the picture
  47. How to insert a variable or formula in a cell definition
  48. [SOLVED] Automatically Auto Filter Worksheet
  49. Conditional formatting
  50. macro used to sort and graph
  51. [SOLVED] Get data from all workbooks in folder
  52. Auto Generate Passwords
  53. [SOLVED] Double click is unlocking worksheet
  54. [SOLVED] Cell formula
  55. [SOLVED] Assign multiple macro to one checkbox!
  56. [SOLVED] collating information
  57. [SOLVED] Sub to detect any change in cell selection within any open workbook?
  58. [SOLVED] VB code to select all rows with data in a column
  59. If statement check
  60. Reordering groups of columns, an error to depurate
  61. Userform help with cells links and macro launching
  62. Excel introduces conditional formatting when moving data using VBA
  63. unhide sheet, copy data, hide sheet - screenupdate = false
  64. Force MsgBox to the front
  65. Excel function that connects to Lotus Notes
  66. Record File Creations within a Folder to a Worksheet Whilst Spreadhseet Remains Open
  67. insert a row
  68. [SOLVED] If Statement to check a cell
  69. Excel 2007 takes forever to export Data
  70. [SOLVED] if and goto statement not working.
  71. [SOLVED] Routing email from Excel
  72. Multiple workbooks with multiple worksheets summed up in 1 workbook
  73. Open worksheet in another workbook.
  74. Reference to xlCellTypeConstants
  75. [SOLVED] API call international settings
  76. Multiple data Collation Code
  77. Create multiple lines based upon criteria
  78. Save multiple workbooks with a range of sheets from original?
  79. Multiplication of textboxes in userform?
  80. date format in save as text macro
  81. Setting formating to columns
  82. Load a macro from pc startup without opening?
  83. VBA Code for Sort - Help!
  84. [SOLVED] How to Read all the filenames from Local drive ?
  85. Email in VBA
  86. Error trap problem
  87. Creating a macro to sort data
  88. tracking sheet history and macros
  89. Macro to alter a variable formula
  90. [SOLVED] rename macro in properties window loses shortcut
  91. [SOLVED] Setting Page Breaks
  92. [SOLVED] Custom Menu code missing or hidden
  93. Help with search/replace formula, VBA or macro
  94. Grab workbook from another Excel instance
  95. [SOLVED] Macro opening list of xls files
  96. [SOLVED] .xlb excel 2000
  97. Let/Get Range for Class
  98. [SOLVED] Macro for Hiding Columns & Printing
  99. Select rows based on colored cells or not
  100. Run Time Error 52- bad file name or number
  101. Please close. I created an easier to understand threat.
  102. ComboBox Syntax
  103. Inverse Matrix
  104. [SOLVED] More convenient way to write an array?
  105. [SOLVED] Lookup/Fill-in form ?
  106. TextBox
  107. [SOLVED] Looping/end on blank
  108. Spell checking certain fields
  109. run macro upon opening the file
  110. Dynamic selection of cells
  111. Excel Code Help
  112. Workbook_BeforeClose and Workbook_Open subroutines
  113. Text Box View Jumping
  114. [SOLVED] No entry to a sheet without a password
  115. Drop Down List Issue
  116. Combining a Userform with Query
  117. If then in vba code
  118. [SOLVED] macro and conditional formatting
  119. VBScript to change color of target if range color is same
  120. [SOLVED] macro progress bar
  121. [SOLVED] sending email by selecting from a lsit of addresses
  122. [SOLVED] Calender enters date into clicked on textbox
  123. [SOLVED] BeforeSave event
  124. macro to count data and produce graph for time span
  125. How to get the right number from Textbox
  126. changing copy and paste code to something more efficient
  127. Hyperlink To Same Value in Other Sheet
  128. Data Consolodation
  129. Making all lists in the sheet to be set "view all"
  130. [SOLVED] Protecting cells in a range, if cells contain information
  131. Need help simplifying a code Please
  132. Formatting a textbox within a userform
  133. Help to Simplify VBA code
  134. remote file update from private website
  135. [SOLVED] Determine if named range is empty / null
  136. Read only message appears when I try to bring up a 2nd workbook
  137. Codes for Matching HSCodes
  138. Data verify problem
  139. Insert Row using Range Object
  140. make custom global functions appear on 2007's autocomplete
  141. Sum of 5 columns. (i know how to do it with functions but not with visual)
  142. Get Data from web via Macro on excel problems
  143. xy chart changing with vba
  144. [SOLVED] can this code copy instead of move
  145. [SOLVED] trouble with rollovers
  146. Disable selection in Pivot table
  147. [SOLVED] Sorting Data by Date
  148. Changing an Image Dynamically
  149. Pivot Table with string as Data Range
  150. Interface for Formula (A or (B or C)) and (D or E)
  151. [SOLVED] Opening Workbooks in a folder
  152. Use Excel VBA to add a hyperlink to a word document
  153. Using VBA to populate a combobox
  154. [SOLVED] Reset parts of worksheet automatically, but not others
  155. Composing a drawing by calling up templates
  156. Second chance on a save
  157. Print Area Page Breaks
  158. Passwording a macro linked to button
  159. macro to select which print tray to use
  160. Time based results. (Updated with 2003 Version)
  161. elseif using formulas
  162. posting variable size data from one tab to another
  163. Hyperlinks not selectable in VBA!
  164. [SOLVED] Password
  165. [SOLVED] "Autoclose after inactivity" macro
  166. Which one first?
  167. [SOLVED] Linking Worksheets
  168. Auto Create New Tabs (Worksheet)
  169. [SOLVED] Ignore Cells with formula and paste
  170. Screen Blue Strip Error after a code is run
  171. Problem with SQL in Excel
  172. Selecting area from a5 untill biggest cell
  173. [SOLVED] Paste value into row.
  174. Macro - Hiding the Columns by Clicking on the Validation tab
  175. modify password protected xls document
  176. Multiple use of one userform
  177. creating a named range and referring to its cells
  178. [SOLVED] Set variable to named range or single cell
  179. [SOLVED] Changing vlookup value in VB
  180. Editting Macro to Select Last Empty Column to Paste Data
  181. [SOLVED] combining specific rows
  182. Autofilter in code
  183. some kind of transpose...
  184. VBA - If Or Statement?
  185. Incompatibility? "Object doesnt support this property or method"
  186. Calculate according to conditions
  187. Inverse and multiplication of Matrices In VBA
  188. Volatile functions across books
  189. [SOLVED] sorting a single column
  190. [SOLVED] Keep Sheet Unprotected but protect some cells
  191. using goto corectly
  192. what are command line arguments to run macro invisibly? and 2 more questions
  193. how to expand just one outline node with vba
  194. xml customer database
  195. Refreshall external data
  196. VBA Printing Macro
  197. Adding code
  198. External Excel Workbook reference syntax?
  199. Data on two seperate sheets
  200. worksheet combo box code runs when workbook open and close
  201. [SOLVED] Select a Combo Box when a SPECIFIC Cell Changes
  202. [SOLVED] correct statement to return time
  203. Get rid of 573.940-
  204. [SOLVED] Changing Number format
  205. copy entire row to another sheet conditionally
  206. Use CDate to get date from dMmmyy string
  207. Adding a new code to a sheet.
  208. [SOLVED] Combo box Additem - Run-time error - Invalid argument
  209. [SOLVED] auto open the excel files in the folder
  210. Reading data from many TextBoxes in UserForm
  211. Charts 5 day moving average, 10 day moving average
  212. Using code to look up objects: code posted here in 2003
  213. Copy Non-Empty Cells Macro
  214. Write formula with a macro
  215. [SOLVED] retaining both cell formats when pasting on on other
  216. Extract and Compile data from two text files
  217. copy/add row macro
  218. Find and compare values
  219. how do i break a large procedure
  220. Insert "Last modified Date"?
  221. [SOLVED] Complie error: End If without If
  222. Run Macro at specified time
  223. [SOLVED] when typing to a cell check if this number exist in a range of cells (in sheet 2)
  224. [SOLVED] Closing a workbook without saving - macro
  225. [SOLVED] Pareto Chart, set line chart origin at zero
  226. Updating a list of data
  227. SUM of elements in diferent documents and columns
  228. Find - not working
  229. Copying rows automaticaly
  230. Split Cell content in multiple cells
  231. Read value of adjacent value of cell and sum
  232. VLOOKUP calculated on different cells
  233. For... Next Loop
  234. count number of instances of a text string in a cell
  235. Copy from one workbook to another
  236. Unbreakable Procedure--Breaking the Escape Key
  237. Get html table from webpage to excel
  238. Select cell that match from other sheet
  239. User Defined Function giving #VALUE! error
  240. Transfer Data To Different Sheet Based on Condition
  241. [SOLVED] Delete sheets in Active Workbook
  242. [SOLVED] Using a macro to paste format until an empty cell
  243. [SOLVED] Match Criteria according to MIN and MAX
  244. Run Time Error '94' Invalid use of null
  245. Variable Word URL Printout
  246. Macro to amend formulas
  247. How to control the Selection.Style
  248. [SOLVED] Display data using label on userform
  249. [SOLVED] Numeric values not being recognize on password
  250. Handling dates in VBA Question.