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. Is my code correct to exact specific data from a cell
  2. Save file with certin Criteria
  3. Class Object Setting
  4. How do I delete rows with numbers ?
  5. Automating a calculation - (Solver)
  6. Getting Meta Tags,
  7. Copy Rows In New Sheet Based On Date Range Criteria
  8. range variable
  9. Microsoft outlook popup box
  10. Sending a message in Excel
  11. Sum of 1st 3 minimum in a row
  12. MSXML2 - getElementsByTagName()
  13. invoice that updates # Auto
  14. Arrays as Function Arguements
  15. Hiding / Unhiding rows when multiple cell values change
  16. Pythagoras in a keypress form
  17. Referring to nodes of objects
  18. Assign cells values to an array
  19. combo boxes and calendar control easy ??'s
  20. Loading a userform when opening a xls file
  21. Duplicate Deletions Macro
  22. Splitting the contents of a cell
  23. Vlookup copy/paste
  24. hiding a workbook when opening
  25. Why this happens ?
  26. Run-time error 1004
  27. Another Data Transpose Question
  28. copy a cell to another depending on the text
  29. Can you use CTRL+Enter to click a userform button
  30. LDdate
  31. On Windows Start-Up
  32. Transposing data to a new sheet
  33. Recovering corrupted files
  34. Tab Index???
  35. Selecting a cell in a certain column
  36. Help with spread sheet (Hard to explain)
  37. Macro to Copy One Collumn to the Next
  38. prevent user moving out of textbox if input is bad
  39. Apply Macro to varying row lengths
  40. A bloat problem
  41. Import Specific Data from Another Excel Worksheet
  42. Autoshapes in Charts bug?
  43. How do I set Pivot Table source in VBA?
  44. Keystroke Macro
  45. Counting a number series plus row delete
  46. cycle Columns, how?
  47. How can I Collapse or Expand Outline in Protected Sheets
  48. Macro to delete old file
  49. Warning - confirm cell change
  50. If statement frustration
  51. Application.Run Range("ScOnWindow")
  52. Macro Question
  53. Form calendar control
  54. Trending Data
  55. navigating the spreadsheet
  56. date and time control
  57. To get information if an other Excel file is open
  58. Selecting directory in VB
  59. Simple question about a Combo Box
  60. Naming VBA Userform problem
  61. Sorting columns in several worksheets and workbooks
  62. Standard Worksheet Size
  63. MSComm
  64. searching list using certain criteria from boxes
  65. Storing items in an array
  66. Disable users from changing workbooks
  67. 2 or more PivotTable's on 1 sheet
  68. Send and receive without display outlook application
  69. Select Next available row
  70. Maximise Form
  71. Select next row
  72. For...Next Values in Macro
  73. Calendar when I select a text box in a userform!!
  74. possible to make sheets static?
  75. The Alt+F4 problem
  76. Count files in directory
  77. Declaring INTEGER vrs. LONG
  78. Calendar Control Macro and Protected Sheets
  79. How to make a pivot table autofresh which is located in server side.
  80. Calculating Dates from a Defined Name
  81. Prompting user to open file
  82. working with new menu items
  83. Creating rows by using a reference cell
  84. good coding practices
  85. Opening a workbook, but not making it visible
  86. save newly copied excel file with no macros
  87. Help match and return macro
  88. Closing workbook
  89. hyperlink question
  90. Create new sheet dependant on Margins?
  91. Need help using columns series or sequence
  92. Closing a Workbook with Clipboard too large
  93. help with a sumproduct problem...
  94. Extracting data from one workbook to update another
  95. loop interrupt
  96. Stuck with a Simple Formulae
  97. time resolution
  98. Using Worksheets from User Form
  99. eliminate repeat entries with a random function and erase the rest
  100. Difference between "empty" and zero?
  101. Macro with two different sheets
  102. Changing cell colour with VBA??
  103. Select, Hide & Unhide Columns
  104. SUM a value from different data
  105. Disabling X button on a Form
  106. Question About Cell Conversions????
  107. Desperately need help with a macro
  108. Probably a stupid question
  109. disable macros, create file, rename etc
  110. Message Boxes
  111. Calculating If's Balance equals then
  112. Using text function with Offset in VBA
  113. Function Procedure Help
  114. How to make a range resizing permanent after macro ends
  115. Checkbox help
  116. Force a new workbook to be readonly with no macros
  117. extern data
  118. HELP macro function called from cell formula fails
  119. hiding things on a userform
  120. problem with formatting a date
  121. copying only cells in a filter with data
  122. Need help with the LIKE operator
  123. Positioning Sheets
  124. Wierd Delayed function error....
  125. ansi to numerical
  126. can't get a macro to work repeatedly on one cell
  127. complilcated iteration
  128. Simple Question, Escape Char
  129. Complicated VBA cade annoying
  130. Create a Row for each value in a Cell
  131. Cutting down the size of .xls VBA projects
  132. cant spot the error in if statement!!
  133. I need Macro
  134. Module precedence?
  135. Macro for Clear contents
  136. Looping through unique filtered selection in VBA
  137. Calculating hours from a time range in text
  138. UserForm Printing
  139. Modify command button visibility with vba code according to user
  140. Formula ideas
  141. paste as a running tallie plz help
  142. Showing some zero values and hiding the rest?
  143. Sheet Protection
  144. Autosum in a Macro
  145. close without saving
  146. import to template
  147. Hide and Unhide Rows
  148. Making optionbuttons disabled on form when first opening
  149. running tallies
  150. REQ:Help with VBA / Macro
  151. How do to search for a string in excel across all rows/columns and save the result?
  152. Reformat Date
  153. Need to adjust existing named range for dynamic charts
  154. Macro that searches a cell for a word
  155. Formula to Insert new row?!
  156. Deleting selected cells
  157. Insert worksheet "X" "Y" & "Z"
  158. error on do until loop
  159. Next row below
  160. Help... PivotTable!!
  161. getting the value of an optionbutton from another workbook
  162. US->UK date change
  163. Best macro for converting currency
  164. defining times in excel cells
  165. Excel 2007?
  166. Pasting a Table as a picture
  167. data save & retrieve macro
  168. Copying worksheets with Formulas
  169. Create New Worksheet for every row
  170. Protect Sheet With Password Using VBA
  171. How to find the value besides the selected option.
  172. changing worksheet names in VBA
  173. auto_open macro to save a specific column
  174. "visualizing" Post hoc pairwise comparisons
  175. Return cell address of an item of data.
  176. Need help to creat a formula/macro for a time sheet
  177. Auto Filter
  178. Column(s) Contents - Unchangeable
  179. macro to run automatically
  180. trying to get comments from sheet 2 to sheet 1
  181. Macro help please
  182. Userform Problem
  183. addapting code
  184. Going back to a form after a error message
  185. Resize forms
  186. formating a cell by vba
  187. integer or something else????
  188. Can this be done?
  189. EntireRow in Shared workbook help
  190. 2 pivot tables on 1 page?
  191. Macro for billing
  192. Macro help
  193. close a connection
  194. Carriage Return multiple entries one cell
  195. Help with automatic save and close after set time
  196. Summary Report Using VB code
  197. Deactivate textboxes
  198. keyPress event
  199. Libraries => Picture Class
  200. Turn of question
  201. interior color VBA????
  202. Please help me
  203. reducing decimal points when returning value in msgbox
  204. Deleting Selected cells
  205. creating counts from a range of cells
  206. Runtime error? Give me a brake!
  207. Macro to sort?
  208. Macro Variables help
  209. commandbutton
  210. Kepping only the correct values
  211. Error running code in Internet Exporer
  212. Creating a database in excel
  213. Code to recalculate certain cells only meeting certain conditions
  214. Pivotcache database stays locked
  215. Event Macros
  216. Code help appreciated
  217. Cell color changing
  218. Help with Poss. Do Until Formula
  219. Goto Command in VBA
  220. Paste special help
  221. Vlookup or other command to retrive data
  222. convert an instruction in vba
  223. Distributing macros to other users
  224. VBA code to save only a sheet under a unique name
  225. Excel Query Variable
  226. click to copy cells and save sheet as
  227. Help needed
  228. Word Wrap for Combo Box
  229. Please help me out
  230. Can't get a "for each" macro to work
  231. Enabling a button if full row is selected
  232. Update Other Workbooks
  233. Newbie: hyperlink to picture
  234. Search from a database sheet in excel
  235. Wrap selected cells with quotation marks
  236. A weird error, no idea why it occurs
  237. a macro question
  238. Remove character?
  239. Deleting empty rows
  240. searching merged cells
  241. Excel Password
  242. Worksheet Store
  243. Macro into locked cells
  244. Problem with querytables from search return page
  245. Add data & print
  246. Autofill Formula
  247. Start Macro on cell update
  248. How to make excel display worksheet 1 of ?
  249. Msgbox background color
  250. Stumper - printing a file based on cell value