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. Copy to tracking log on network - Feasible?
  2. Translating Months into Quarters
  3. Looping through all Workbooks in directory to retrieve rows of information
  4. New sheet
  5. inputbox for simple verification purposes?
  6. Email a macro?
  7. Creating a list of buttons to make selection
  8. Working out waiting times.
  9. If no items in column sort - how to stop macro copying all entries
  10. looping through range of cells & sending multiple emails with outlook
  11. Changing the color of Points in the same Series
  12. macro save 1 plot every 2...
  13. Importing Data from one workbook to another
  14. Saving without Compatibility Checker
  15. Don't select a cell after macro runs ???
  16. Find all "" and delete line
  17. Naming sheet with cell value in another sheet
  18. Search range and save to csv file
  19. What's wrong with "formula" line..
  20. Delete rows
  21. Manual calculating selected cells only
  22. Find Distinct Values
  23. Open IE with Excel
  24. Copy & paste dependant on month
  25. Adding the values on even rows/odd rows.
  26. Automatic Password Entry
  27. Macro - find that missing date and generate a day
  28. Condensing Find Code
  29. VB References
  30. Add-ins??
  31. Macro that uses System Date in conjunction with Conditional Formatting
  32. Changing font color in worksheets
  33. Cell Shading Macro Depending on Text
  34. Cell Reference list for "Order1" sorting choice
  35. Cancel property in Input box
  36. Re-arrange data in one column into multiple columns
  37. Check Boxes and the Macro Requirement
  38. Issue with programming.
  39. Validate, then Copy and paste.
  40. excel program giving up halfway through calculation
  41. removing aol addresses
  42. Disable Editing a Cell Without Protecting the Worksheet
  43. Sum until there is a space (complicated)
  44. Macro Save File As XLS
  45. Sum until there is a space (complicated)
  46. back up with macro
  47. Merge two worksheet into 3rd sheet (modifying a macro)
  48. Delete rows without a specific value in a cell
  49. how can a macro end another running macro
  50. Forms and Arrays
  51. .wav file is played on change in Column
  52. Adding Or Removing Rows Dynamically
  53. Move Row Up To Top Of Sheet
  54. find file in directory, copy and paste worksheet
  55. how to filter and copy data from one sheet and paste to new worksheet
  56. type mismatch problem
  57. vlookup on web based excel spreadsheet
  58. Using dates in VBA
  59. Conditional Formatting in VBA
  60. Data import overwrite dilemma
  61. Multiple criteria from one sheet to another, vlookup?
  62. Autofill Last Row Data
  63. Hiding Macro
  64. Sorting and conditional formatting
  65. Changing sheet protection in 'real time' with VBA ?
  66. Save worksheets as PDF
  67. Code for Cell border styling
  68. Import data from different closed workbooks
  69. Macro/If Then statement to move a row of data
  70. If/Then Statement to move row to a different sheet
  71. Excel addresses generate maps?
  72. Access a hidden sheet (confidential data)
  73. Highlight Duplicates based on 6 col
  74. List box and right click menu
  75. Insert calendar result into lock cell
  76. add a menu on the application menu bar
  77. paragraph of information.
  78. Run Time Error
  79. Change cell border & outline in a macro
  80. How to check Read Only status for active workbook
  81. Add-in Basic stuff
  82. List box with a divider between selected and unselected
  83. Cell Shading Macro Depending on Text
  84. Formula using Row Count
  85. Macro for "Text to Column"
  86. Insert External Data
  87. check if any cell in a dynamic range is empty
  88. Loop function with vlookup
  89. Using a variable in a userform label
  90. Repeat Merge
  91. Call a macro from your personal workbook?
  92. Define variable range as named range
  93. Pls help:To copy worksheet from any folder
  94. Date Macro
  95. Add data to column filter by data in other column
  96. Hide the sheet no. & creating messagebox
  97. Listing Unique Values from a Column
  98. Copy only takes som of the data
  99. Finding sums of groups of data
  100. Using a data form in a macro
  101. is excel macros different from sun open office macros?
  102. Finding unique combinations of 2 columns
  103. Date conversion to another form
  104. Dynamic Range Creation
  105. List files in folder
  106. Copy with Number Formats
  107. Print specific pages based on specific cells
  108. Formatting Objects and Text within a Chart
  109. Change source data of existing PivotTable
  110. display a message, before calling the function
  111. Issue writing a loop
  112. Filtering For 2 Entries
  113. Pivot Table Code Question
  114. save,close then reopen original
  115. Udf
  116. calculate fees from table
  117. Get Number
  118. Select Tab with Data on Clipboard
  119. excel coding help
  120. Code problem in Excel 97
  121. Counting elements in an array
  122. How to Validate Row has no blank values
  123. Format data using macro ...
  124. Force to open in Excel not IE6
  125. Extracting data from the offset of a cell, to be put into a new sheet
  126. FX_DIS11 Module Auto close error
  127. using index in for loops
  128. Getting the location of a button on a sheet
  129. Help automating a process
  130. Conditional cell lock
  131. macro to return to where user was working
  132. copy worksheet to another excel
  133. concatenation question
  134. Simple Row Deletion Macro
  135. MsgBox
  136. Compare Values
  137. match string to values in worksheet range
  138. Specify |a| to become cell with "a"
  139. Simplifying the Code
  140. Automatically selecting print area based on Pivot Table size
  141. Basic Formatting help
  142. Populating Combo Box
  143. Pastespecial - paste values
  144. Timer in User Form Box
  145. Getting Entered Userform Values set as variables
  146. Macro to cut and paste random rows
  147. html in .send
  148. Convert Text to a Number - VB Code Needed
  149. Unhide rows in all worksheets
  150. Clear Contents of a Cell
  151. Macro to activate a filter on another sheet
  152. Find Column Number and then use Index Function
  153. Run a macro only when a specific cell value is changed
  154. Copy Figures, buttons.
  155. Leap year
  156. Copy and Paster an autosum to new workbook
  157. VLookup Two Workbooks
  158. infinite UsedRange due to hidden columns
  159. Runtime Error '3001' Invalid Argument???
  160. Sort variable range via macro
  161. find a directory
  162. restarting a script after user input is completed
  163. Macro to create Table
  164. RefEdit error in Excel 2007
  165. send mail to a list of destinators
  166. Macro that pulls values out of an array based on its formatting
  167. Getting the Maximum Record # in Access
  168. Current User
  169. run macro by changing cells value
  170. Functions and arrays
  171. Range.Formula becomes error/undefined
  172. protect excel
  173. Cut Paste data basis criteria
  174. Run macro in workbook B from a macro in Workbook A
  175. How to declare variable names depending on worksheet names
  176. Copy Rows with Certain parameter to a fixed Coloumn
  177. File Open List in floating box
  178. hiding the worksheet wrt. given value in a cell
  179. Unexpected SelectionChange event code
  180. Search for column heading and copy column onto another sheet
  181. macro calling two diffrnt macros at different time intervals..
  182. general excel to control mail send
  183. stock audit & bar code scanner
  184. hide the row & one cell
  185. Adding help text to a user-defined function
  186. How To Call It
  187. simplifying copy to another workbook code
  188. Get last 2 characters of a string
  189. Delay
  190. How to use the Workbooks open event?
  191. Quick "msgbox" question (Visual Basic) / Allow user to respond with text ? [RESOLVED]
  192. Cannot gain Value using offset
  193. Problem Deleting Row
  194. Arrays & Ranges as Parameters
  195. Excel VB new Workbooks
  196. Adding a title to a dropdown box
  197. Setting a Global Variable
  198. ScreenUpdating = false: more than once in the same sub()???
  199. Linear interpolation/extrapolation module - input?
  200. Formula/Macro to Check Column and Copy Row to Other Sheet
  201. Sorting A Range based upon one row
  202. Split Cells - Do I need a Macro
  203. listbox comparison
  204. Error Trying to email attachment
  205. Convert VB macro to applescript?
  206. Error Handler
  207. Save current active sheet only
  208. Help with Object Error
  209. How to reset all combobox ant textbox with one command?
  210. macro that runs automativally every 15 minutes
  211. How to create dependent lists from database data
  212. Send HTML E Mail From Excel
  213. Data Validation + macro to hide sheets
  214. Worksheet lock based on time
  215. Error in Text to Column Code
  216. Find two cells then return value at intersection.
  217. Find Data on One Spreadsheet Based on Name & Place into Another Spreadsheet
  218. Me keyword
  219. Decimal Point is not allowed
  220. Check Strings
  221. vba to step thru and edit data
  222. Variable not available
  223. macro to check internal ips
  224. Drop down validation cell question
  225. Connections to xla file
  226. Userform properties
  227. Search for variable and copy row
  228. Amend an if statement
  229. copy rows to a new sheet, if column criteria met
  230. Testing if a network file exists?
  231. Error with Code within Spreadsheet'
  232. Adding a new column at the end based on the first row
  233. Identify missing numbers
  234. Sort certain rows with macro
  235. No added menu when workbook opened with macro
  236. Coloring cells
  237. Conditional Array?
  238. find function and relative reference
  239. create an addin that will automatically load itself
  240. get a workbook in excel to email out through gmail not outlook
  241. The calendar userform appears blank
  242. Fill across all sheets except the first
  243. function used to add/remove cell comments
  244. 2D Array of named ranges
  245. SQL to Excel - Stock sales by month
  246. Rows Spacing, Column Spacing
  247. Determine future dates based on selected days of the week
  248. R1C1 vs A1: Add to column "A + 1"?
  249. Pasting formula from code
  250. creating a function that maps to a large spreadsheet