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. Formating with a macro
  2. Making this code work
  3. Need a macro to search and remake any list
  4. BRILLIANT EXCEL ADD-IN IDEA - Requires Calling a DLL Function Written In C
  5. Format Currency in VBA
  6. Making Spreadsheet Run Smoother
  7. [SOLVED] Monthly, Quartly and Yearly dates
  8. Excel 97, common eventhandler procedure 4 all controls? possible?
  9. First Time Poster - Questions about Grocery List
  10. A macro that can deal with multiple files?
  11. Check if Add-in is Loaded
  12. worksite imanage
  13. clear cell contents if not a formula
  14. Extracting the class C address from an IP address via a formula in Excel
  15. Printing Macro
  16. New Student Macro GAH
  17. Files will not open in macro?
  18. help advice needed
  19. This routine just keeps on going! Why?
  20. Fill listbox with values from an other worksheet...
  21. registration code
  22. Fill several comboboxes with same info
  23. Trying to CONCATENATE /add some data in a macro and am lost
  24. hi
  25. Gridlines, Rows & Columns Headers Problem
  26. Need some help with this code
  27. Whats wrong with this code??
  28. Links in Excel
  29. matching text to numbers
  30. Calling Solver
  31. Modify Auto Sort Macro to delete Duplicate entries
  32. Highlight/Move Entire Row If...
  33. Save new workbook with specific file name
  34. Macro to Create Control Chart in Excel
  35. Open word document and put cell value on 4th line
  36. Automatically open another worksheet. . .
  37. Hi Please help with excel and sql..
  38. worksheetfunction.vlookup result when search argument not found
  39. Copying a Formula but using current row details
  40. Help with 'Workbooks("xxxxxxx").Activate'
  41. hi
  42. hi again
  43. Help ! Array? SUMIF? COUNTIF?
  44. Macro
  45. Question Regarding Conditional Formatting
  46. Mimic another worksheet
  47. VBA Do...Loop Statements
  48. Paste back to relevant cells after editing
  49. Class Module? Using an index?
  50. Showing/Displaying Message to User
  51. locking a data validation list based upon cell value
  52. create dynamic ddbox in excel with vb
  53. Excel - Vba - Outlook
  54. Is there anyway to link a hyperlink to a macro?
  55. Further breakdown data from "New Web Query"
  56. Macro to fix Misaligned Data from .csv File
  57. Don't save unless a certain condition is met
  58. Brainstorming ways to insert online data into spreadsheet
  59. Loading Specific File
  60. Worksheet_Change function
  61. error in formula
  62. Building a matrix
  63. Can I open a .PDF file using macro
  64. Excel does not give me the chance to enable macros
  65. disable macros
  66. disable macros
  67. Worksheet_Change cannot pass Target argument
  68. Evecute macro via button
  69. Please help me with a simple VBA function
  70. Share Workbook - Update Changes
  71. [SOLVED] Bypass "Read Only" Dialog
  72. Object required? C'mon!
  73. Pull (Extract) the First Letter of a String
  74. Opening a Long URL
  75. If Worksheet is Protected then...
  76. Copying an Excel chart with VBA
  77. I want a better solution
  78. Request Proposal
  79. Workbook Name call in macro
  80. If - For - Vlookup working together
  81. Negative Sign on Right Side of Number
  82. Little Looping
  83. sum in list
  84. Turnoff Calculation
  85. Application.ontime in XL97 Irritation
  86. Weird Problem
  87. Muultiple userform 'reset' code question
  88. Finding suitable graph sizes
  89. Do...While...Loop...Help!
  90. MsgBox Retry button
  91. How to write this macro?
  92. [SOLVED] Multiple Macro's
  93. Macros link problem?
  94. Cancelling Hyperlinks
  95. Paste to location based on Cell contents
  96. Save File From Hyperlink
  97. complicated calculation
  98. Relative paths / links in macro
  99. Using code elsewhere
  100. Help making code run faster
  101. Passing arguments when opening Excel
  102. Whats up with this code?
  103. Code help needed.
  104. Search using 'Application.FileSearch' ONLY lowercase filename
  105. Filling a listbox with values
  106. Ontime Mehod Help
  107. Please Help
  108. VBA Scripting Help!!
  109. Flash 5 or 6 digit random numbers on a screen
  110. macro to disable makros
  111. VBA to increase cell entry by a month
  112. Select range by date
  113. Macro worksheet protection policy
  114. Runtime error '9'
  115. Remove blank rows and columns
  116. data more than rows
  117. Replace all 30 times
  118. Hiding columns with no data
  119. Macro that shares a workbook
  120. Not Numeric Variable?
  121. [SOLVED] Transpose
  122. Call macro via command button
  123. Incrementing a column code help needed
  124. Numeric values vs Char/String values
  125. Referencing a variable in place of worksheet name
  126. Code cleanup help appreciated
  127. How to Run Macro When Excel Opens
  128. Changing same macro in multiple workbooks
  129. An innocent looking piece of code going wrong
  130. VB Textbox Turmoil
  131. Macro for Paste Special Values
  132. Highlight & Copy Cellrange with Data
  133. Renaming FILEcurrent to FILEold
  134. ActiveCell is Query Table or Pivot Table?
  135. Problem with finding the right formula
  136. Improving my format-macro
  137. VBA to send a message from outlook.
  138. move column data into rows
  139. VBA error msg 1004 - pls help
  140. Running Total? Any help?
  141. Combo Box trouble in excel
  142. How to select / deselect series in chart by VBA?
  143. copy yellow cells on sheet 'quote to sheet1 via a command button
  144. challenge - flat file creation
  145. Redim Preserve 2D Array
  146. Textbox only date format
  147. FormulaR1C1
  148. Finding next empty row in another worksheet
  149. Nested conditional statements
  150. Need a macro that will read rows and...
  151. VBA Range Selection Help
  152. SendMail woe
  153. Color Indexing
  154. Changing workbook names from read-only to not
  155. Column headings
  156. deleting rows with a zero
  157. How to start the userfrom when opening xls file?
  158. Can a chart be displayed on a user form ?
  159. Simple autofit macro crashes.
  160. Using variables to define a range
  161. Disabling the concurrent user notification box
  162. AUto date and time
  163. Macro
  164. can a cells content be changed through a custom function
  165. Copy and Paste with VBA
  166. Excel file Problem
  167. New to VBA-Problem might be solved with a special formula-need help!
  168. Msg Box visible
  169. Check if file is open
  170. Perhaps most easiest question
  171. Find and Copy
  172. conditional delete rows with special time
  173. Question on Blank cell
  174. Macro that copies results from formula cells but not the formula itself???
  175. Getting range of cells with specific text colour, then using in a COUNTIF formulae
  176. copy paste
  177. position of shape
  178. New sheet at End of sheets
  179. How to open a userform just by clicking on a cell
  180. Who wants a challenge?
  181. Multiple Results On Search
  182. Annoying Userform Problem
  183. Complicated data lookup report
  184. VBA to run on load
  185. Great Site and Thanks For the Help
  186. Outlook application
  187. Counting rows with two qualifiers...
  188. Dynamic worksheet reference
  189. Arrays - Rows and Columns
  190. deallocation of array
  191. VBA problem when adding two cells
  192. Printouts on multiple sheets with progressive page numbers in footer
  193. Find And Color
  194. Need help with (possibly) macros?
  195. Confused by Add-ins
  196. Can Sheet1!A1:A8000 be used as variable in formula?
  197. Finding Formulas
  198. significant digits and arrays
  199. Enabling Spell check on unlocked cells in a protected worksheet
  200. Adding help text to a user-defined function
  201. Programming with Autoshapes
  202. TextBox and Label Assignment
  203. How to disable Esc Key
  204. Moving Values From A to B - C - D - E
  205. How to make a button that changes a cell value ?
  206. Loop through checkboxes
  207. VLOOKUP with multiple identical keys !!!
  208. worksheet_change and dropdown data validation
  209. saving a file with a cell value as the name
  210. Runtime error....Problems with workbook selection
  211. Pivot Conditional Format
  212. Retrieving a Value from a Cell and adding text to it
  213. ListBox and activate Macro
  214. Programming with Solver
  215. about string
  216. Formula Help: Vehicles On Railcars
  217. range selection
  218. Tool Bar Programming.
  219. Opening Multiple Text Files
  220. Stop indifinite Msgbox loop in Worksheet_Change event.
  221. ranges
  222. protect code
  223. Vlookup & VBA
  224. Quick simple question!
  225. Need query that will delete based upon column value
  226. choose data range from list
  227. Defaulting MS Date Picker control value
  228. Creating a new workbook and referencing it
  229. Linking List box to MS Access Table
  230. VBA Wildcard
  231. How do I paste a formula (which contains dbl qoutes) in a cell
  232. Need help counting
  233. Start macro on cell input
  234. CodeModule crashing exel - Any ideas why
  235. General Excel Programming questions
  236. Fantasy Football scores calculations...
  237. Date Compare
  238. Setting a cell's value as a formula containing quotes or double quotes using vba
  239. Scroll Bar
  240. String converts to date - text doesn't help!
  241. Getting Workbook Properties
  242. UserForm Code Question/Help
  243. problem with "Next Cell"
  244. Copy a selected range of data
  245. How do you end VBA code???
  246. automatically running a macro by selecting a worksheet
  247. What's the Difference?
  248. Starting a Macro After Another
  249. Button on toolbar
  250. Move data to column A