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. Using userfrom to add a new row, column
  2. Outside data error VBA
  3. In need of a Macro dealing with images
  4. if statement using a range of dates?
  5. Using VLookup to find closest match
  6. Macro doesn't repeat manual actions
  7. Need help with +1 counter on invoice number and copying macro
  8. Find and Remove Row
  9. Macro to create copy of a .xls file (Beginner)
  10. list box script problems
  11. Show date/time in a pre-determined column when data in row is edited...
  12. Adding in a "header" copy to existing macro
  13. For statement leading to error 1004
  14. Find and Delete
  15. Setting variable data-sort ranges
  16. Validation code
  17. Open file based on cell data
  18. How to Read/Write Data to/from a closed workbook
  19. Protected data entry
  20. Cell references when using macros
  21. VBA Range Recalculate Locks spreadsheet
  22. How do i create a launchpad for this?
  23. How to read the column which include text and number in the excel via ODBC?
  24. Shared Workbook problem..
  25. Macros for Inserting rows
  26. Quality report system
  27. Algorithm to change format of specific cells
  28. For Next Loop to Transpose Data
  29. Generate a list from other lists
  30. look at the sql to join two table?
  31. Programming Outside of Excel Not Recognizing Excel.Visible
  32. Sum a Dynamic Range
  33. Remove duplicates from col.A and merge col.B
  34. Multiple Choice from List Box
  35. If Dictionary Exists
  36. Type Mismatch error 13
  37. creating numbered purchase order forms
  38. How to convert some columns in Excel to the datatype I want to?
  39. control worksheet scrollbar using userform
  40. Enter data in Master cell an copy to another
  41. using current workbook...
  42. summary of data on another sheet, sorted in data type
  43. Calling a textbox in a group
  44. Multipage problems with second page
  45. Validate cell using VBA
  46. Excel Control Toolbox
  47. Pivot Field VBA Question
  48. Importing Web Data Weekly
  49. creating a work roster generator
  50. How can I PUSH Data from one Worsheet into another Workbook?
  51. type mismatch error in code
  52. macro to download file from FTP and import to excel
  53. Sort and chart multiple series from raw data using macros
  54. IE pop up confirmation box
  55. SendMail Problem
  56. modify a macro; run macro again automatically for next cell if any error accurs
  57. Automatic links Message on Open
  58. Amend filter code to work with combobox
  59. How do I conditionally delete duplicate entries?
  60. Pass a file name as a variable
  61. Auto Send eMails From Excel Using My Menu
  62. VBA code line OK in earlier versions but not in XL 2007. Why?
  63. filter data on all worksheets using checkbox on userform
  64. Textbox in Userform showing cell data
  65. macro that adds one column every time it's run
  66. Adding Data to Chart, Anyway to prevent flashing when changing sheets?
  67. VBA Macro as an Add-Ins
  68. Filter / Macro
  69. End Of File
  70. vlookup vba formula
  71. Else without If
  72. Subscript Out of range
  73. Looping question
  74. If..Then..Else and ActiveCell code
  75. Program (outside of excel)
  76. disable validation on duplicate cells
  77. How To Enter A Value To A Cell With A User Form??
  78. Basic loop error
  79. Update from one workbook to another
  80. edit comments by macro
  81. Filter rows with same dates and keyword from description
  82. If..Then..Find ..Replace
  83. Show cell comments in userform text box.
  84. Delete a range of rows above blank cell
  85. IF query between worksheets
  86. Hosting Excel in Winforms Application
  87. How do I make a userform to appear when I hit a button on the worksheet
  88. Create Subset chart/data
  89. select multiple columns macro
  90. Find and replace in a column and delete row if cell equals x
  91. Get data from a column
  92. Auto insert row based on data
  93. How to create a Macro to carry over cell amount
  94. VBA Copy
  95. Show date/time of when cell/column was last edited?
  96. Creating custom buttons for macros
  97. Tab renaming
  98. Average value of A1 on every sheet in the workbook?
  99. macro web query
  100. Data Import issue
  101. Schedule report - to be generated for each individuals
  102. Summing column and move result
  103. Column width issues....
  104. disable command button once data is recorded
  105. Calculating Combination Totals
  106. Excel to Output Data to Other Excel File!
  107. converting US Date format to UK Date format
  108. Interactive TextBoxes
  109. automatic 24h day
  110. Macro Problem sending Worksheet by email
  111. Microsoft Office Excel, Unable to get the Insert property of the .... Exel 2003
  112. Concatenate
  113. How to format on Workbook Open
  114. Dates Problem
  115. Trasfer values to Text Box during runtime.
  116. data validation
  117. Copy Row based on cell entry
  118. Code to find a specific word???
  119. Print Run and sheet update
  120. Email stock database to user when sample expires using lotus notes
  121. Excel 2007 to Acess 2007
  122. Pasting to Hidden Worksheet Results in Run-Time 1004
  123. Conditional formatting between sheets
  124. Compile a Value in VBA Instead of Cell
  125. A macro to copy and paste four rows
  126. Clear cells depending on data validation list output
  127. Average of a Cell on Different Sheets Compile Error Possible?
  128. Automatic Running Macro
  129. Refresh Data gives shut down error
  130. Close sheet if no webdata available
  131. Activate workbook from input box
  132. on time to run 2 macros and pop up box
  133. Calculate Sheet
  134. if cell has data or values then cannot overwrite
  135. Code won't copy from one sheet to another
  136. automatically inserting new row/line
  137. Row-adding macro causing hidden row weirdness!
  138. automatically inserting new row/line
  139. Plotting Voltage Changes"
  140. automated copy in table
  141. Using AutoFilter with a defined variable
  142. running Macro on a Protected Worksheet
  143. Show Message Box When Cell Is Filled In
  144. Data Extract
  145. stock prices; EOD data from internet
  146. Allow User to Choose File to Open
  147. Find & Replace only specific data
  148. Converting individual cells within a range from minutes to decimal hours
  149. Need a VB code to generate sheets from a list of cells
  150. Copy cells to new workbook based on date
  151. Can I open a file in a raw format?
  152. E-mail
  153. Look for Value & Occurance of Number in Sheet then Copy to New Sheet
  154. converting rows to a single column
  155. Picture loading in image problem
  156. Update presentation from excel
  157. Checkbox MsgBox
  158. If cell =X the vlookup and return value Y- only at98%
  159. Button list
  160. Why does Excel change my RC Formula?
  161. Sum Cells
  162. Date Picker from user form
  163. time returns a decimal value when searched
  164. if then next
  165. How do you protect user from fixing pagebreak and pagesetup?
  166. vba: group data from csv then import into worksheet
  167. Matching up variables in VBA
  168. if condition for blank cell values
  169. How to create an excel sheet for different .txt in different folders
  170. Using a parameter in a macro
  171. Run-time error 1004
  172. Error on Setting Range
  173. Block ustom toolbars, menus, shortcuts from other workbooks
  174. Message box based on user entry in cell
  175. [SOLVED] using if statement for getting time difference
  176. Linking two spreadsheets
  177. Trying to delete rows
  178. .name in small not cap as .Name
  179. Auto-insert Rows
  180. Date Format and Entry
  181. How to insert formatted row using Macro?
  182. keeping part of a string
  183. Fixed Date in cell, triggered by input into a different cell
  184. I need help with this Macro, if it is possible
  185. activateing a workbook
  186. modify all selected cells
  187. Auto response to Pop up window
  188. [Req for help] Lotus plus Excel.
  189. Display of Combinational Chart
  190. Finding and displaying cell address of cells matching certain criteria
  191. Print preview not matching to page count
  192. How we can find that whether a particular column exists in the Excel file or not
  193. Selecting cells using variables for row and column values
  194. linking workbooks
  195. Button - Send email
  196. Declare datatype
  197. Open the latest file to copy and paste data in another file
  198. How to exit a series of subs if cancel is pressed
  199. Code to find all occureneces of the same last name and list them for user to chose.
  200. Cost of Sold Calc
  201. Using the Microsoft On-Screen Keyboard in Excel
  202. when a cell is added in one worksheet, change another worksheet
  203. Repost correction Using a cell to enter a date and have it copy it to another cell
  204. Copy formula when Inserting rows
  205. Modify Autocomplete to keyboard activation
  206. Isolating last line from a group. VBA?
  207. Compare 3 cell values
  208. Listbox selection from another listbox selection
  209. Finding the internal index number of a Chart Series.
  210. Auto completing information based on drop-down content
  211. Converting imported data to columnular data
  212. Macro to Shift Chart Source Data
  213. Errors on If Statements
  214. Appyling codes
  215. Combo Box Drop Down/Editable
  216. Macro to pick data from one worksheet to another
  217. disbling the annoying F1 key
  218. ListBox Problem
  219. Excel REFUSES to Listen to me regarding Date formatting
  220. AttachLabelsToPoints and named ranges
  221. Adding rows - same amount of rows as value in cell
  222. Advanced Find using a Form
  223. Protected Combo Box
  224. Need to auto set print area and add comment to last row
  225. Auto run macro on File->New->Template
  226. Run time error: Type mismatch
  227. macro to include cell contents b1 in file path
  228. Improve slow code - programming a sub which displays a polynomal function
  229. Changing Relative to Absolute and visa/versa
  230. Insert a picture from an UserForm
  231. Store Bitmap Object In Excel 2003 To Access Database?
  232. copy formula from first row to next row but changing the file name in the formula
  233. organizing data
  234. message prompt appears to be delayed
  235. fill a color green for 1 and white for 0
  236. Copy Rows from Sheet 1 based on Criteria
  237. c# DLL called from Excel 2000
  238. Automatic Sub Totals
  239. filter randomly based on inputs
  240. Sort & Filter Unique items
  241. automatically importing data from another sheet
  242. Call Macro in another workbook
  243. Macro - Using Sheet Template Need It to Auto-Rename
  244. machine monitoring
  245. how to drop names down a line
  246. Hiding selected columns
  247. vlookup of hours in user form
  248. prompt message box of the time remaining
  249. Copying from one cell, into the next empty cell in column A in another workbook
  250. Test for "if selection includes cells outside range"