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. ActiveWorkbook.SendMail and IE - odd problem
  2. Creating a Help file
  3. Pull data from multiple workbooks into one
  4. UDF to Display Results Vertically Instead of One Cell Horizontally
  5. Excel macro for printing multiple sheets...
  6. randon number
  7. Weekly List
  8. How to change the Sheet name of a workbook from a macro present in another workbook
  9. Macro: checking if any workbook is open
  10. Copying a date from one workbook to another
  11. Cell formatting
  12. Summing up of Values from Different Workbooks after meeting certain criteria
  13. UDF Question -
  14. ACSII value of the character
  15. .xla addin reference in Excel
  16. Listbox (MultiSelect)
  17. more than 1 name in cc list
  18. "Translating" numbers into words
  19. Copy spreadsheet with different names
  20. Set Page Breaks and Print Area
  21. Calculating Sum based on a group of numbers.
  22. Autofill error
  23. VBA Excel List Box - Refresh Problem
  24. Export data to either CSV or XML
  25. Looking for Excel/VB/SAS programmer
  26. Would Like to change color of cell when I get a Return of False(Red) True(Green)
  27. Row and Column Returns
  28. Non repeating Randomized Number
  29. Storing a subjective range
  30. running macros in the background
  31. Add datatable to existing chart
  32. Enter simple changing formula in many but not all cells
  33. check for illegal characters
  34. Close excel from vb code
  35. Hide all menu/format bars display full screen
  36. Formula resulting from macro (not updating?)
  37. Exporting UserForms and or Modules
  38. Remove Duplicates not removing all duplicate entries
  39. Keydown rather then range
  40. Converting weeknumber formula to VBA (array constants)
  41. Number all non-blank rows
  42. VBA Select dynamic workbooks.
  43. Transposing data
  44. Macro to copy down formulas adjacent to data.
  45. Create an external txt file using VBA
  46. Automatic table creation
  47. Showdataform method
  48. Want to run a macro before closing a workbook
  49. cell formatting with concatenate VBA
  50. Range("A1").select Error
  51. multiple worksheet copy and paste formatting question (using VBA)
  52. Macro Iterating through multiple cols and Creating a Strings
  53. Macro to move a cell right every time it runs
  54. List Pivots in workbook & Sheet Location
  55. Excle data file and macro publishing problem
  56. Changing first letter to caps, letters after "-" and "/", and rest to small letter.
  57. get cells value
  58. Macro to copy data to remote workbook
  59. Verify Date Format
  60. Search VBA causing error when data isn't there to find
  61. Macro to sort worksheet by the column of the active cell
  62. Search for the next empty row?
  63. Use of VBA with Comments
  64. worksheet change event
  65. Add-In works until Saved As Add-In
  66. code not working
  67. Returning collections?
  68. Concatenate string and function
  69. Save As FileName
  70. Pop-Up Calendar
  71. Create New Book Using VBA and/or Macro
  72. Process and declare a character array
  73. Organization Chart
  74. Skipping Code (for testing)
  75. VB code to open a file that user chooses.
  76. Custom Order Template VBA or Macro
  77. Copy rows from work sheets to combine to one work sheet based on cell value
  78. Check if chart exists
  79. Changing Cell Value (adding extra text)
  80. Defining a range
  81. Check for xls file in folder
  82. Trying to better understand ClearContents loop
  83. speed of running vba script
  84. email function
  85. Convert Numbers into Text
  86. Event of selecting Page6 of MultiPage1
  87. Action not changing to General Format
  88. How to refresh functions(takes values from another workbook) in VBA
  89. Collecting data
  90. Trouble with Formula (in loop)
  91. How to import wrapped data from csv file
  92. Insert blank row, sum and insert page break macro
  93. Search and move cursor position
  94. Workbook Open, if its already open, Activate
  95. Using Check box to select code to Run
  96. delete menu items
  97. Run-time error 13 "Type Mismatch"
  98. How to selectively add numbers for different products?
  99. "Popup question button" when initiate a macro
  100. Amend Upper Case macro to ignore brackets
  101. Selecting dynamic ranges
  102. Macro to select last row with data
  103. pulling data from multiple workbooks
  104. autocad object coordinates
  105. Copy multiple sheets to a new sheet
  106. auto insert column when sheet is opened
  107. Trouble with personal macro workbook
  108. updating a filename upon saving
  109. Autofill in a Macro
  110. Insert images throughout worksheet.
  111. User navigate to sheet in workbook mid macro
  112. How do you Uncheck Option Buttons by row?
  113. Row Color Change Problem
  114. How do I use VBA to choose the source cells for a list with Data Validation?
  115. Save As code error
  116. Stop Combo Box from changing my value
  117. DDE Functions to open, save, rename, add sheets, etc.
  118. create automatic sum
  119. Multi conditional formatting
  120. link to email
  121. closing a sheet after webdata expires
  122. Find the row number of the first cell entry in a column
  123. step into a macro and see results
  124. Updating sheet without re-opening...
  125. run an Access Query From Excel..
  126. reorganising data
  127. How to link to another workbook for SQL.
  128. Change data source of pivot table using macro
  129. where can I get ultimate plugin
  130. Speeding Up VBA Programming
  131. Trouble with personal macro workbook
  132. Identifying XLS Workbook
  133. trigger a macro when changing a cell
  134. Macro button to filter and display
  135. Create a macro to blank cells in a specific workbook - Excel 2003
  136. Problem concerning renaming of items in Pivotfields...
  137. Time in Userform -> textbox
  138. Generating report based on and consisting of rows in worksheets
  139. Summing per Criteria
  140. Copy last row down a row
  141. disabling the enable macro alert
  142. strange run-time error 1004
  143. Using Autosum at the bottom of a variable range
  144. Adding Greek letters
  145. how to run a macro upon selecting an item from drop-down menu
  146. compare 2 range
  147. String=String
  148. List2 based on List1
  149. copy sheet by reference number
  150. highlight if cell is modified
  151. link to other sheets in formula
  152. customizing data output in xy scatter
  153. VBA or VB.net?
  154. Drop Down Boxes & assigning them Macros
  155. Coding the page setup efficiently
  156. protecting a workbook but still able to run macros
  157. Beginner trying to write a macro
  158. subscript out of range.
  159. Column ref - quick question
  160. Macro to add cell below to activecell
  161. My italics are being un-italicized
  162. Excel does not recalculate when calling VBScript
  163. Disable Command Button
  164. Processing speed
  165. Changing Cell Value with VB
  166. Email to address entered in cell using CDO
  167. Reading Class Information Backwards with a loop
  168. Pranks 2008
  169. Inserting a dialogue box using a macro for financial projections
  170. xlFilterCopy will not work
  171. Copying 2 paragraps in Word.Range to Excel.Cell
  172. SaveAs without Prompts
  173. Macro when open the workbook
  174. Pulling External Data with sheet that never closes...
  175. Find duplicates over 60 workbooks
  176. Search a database of telephone numbers and display results
  177. select case with if and cell value
  178. Date changes to US in Macro
  179. Different Title rows and footer
  180. comparing rows and columns name
  181. return single result from multiple rows
  182. Open Excel File from Number in cell
  183. Populate a UserForm
  184. Vertical Lines On X-Axis
  185. Protecting sheet with VB
  186. Select Range using variables
  187. Drop down list
  188. Excel 2007 macro .. Add a icon to toolbar
  189. Summing Column
  190. COUNTIF-type loop with multiple logic requirements?
  191. Find based on cell value on another file
  192. Delete Selected Row Not Working
  193. Looping -import each text file into a different worksheet and insert a chart
  194. Copying into excel range from word range with formatting
  195. change extension in vba
  196. update a invisible worksheet
  197. Open a workbook with vba code if already open do...
  198. copy cells
  199. Data Import Problem
  200. divide variable value between variable cells????
  201. Macro won't loop in Dutch version
  202. Filter an Array
  203. List Box, Set to 2 decimal places
  204. Excel coding - Multiply activecell by 2
  205. Run Time error 438
  206. Auto Sorting a Filter
  207. Run Sub if range("f6").value changes
  208. Searching for dates which satisfy a range
  209. Normal distribution
  210. Data Import Macro - can't copy the value to the worksheet of GetData.
  211. How to add more conditional formatting conditions than 3?
  212. Excel Function Output not updating
  213. Rearranging many charts at once
  214. Stopping user saving unless condition met.
  215. How to refer the values in another workboox using Macro/formula?
  216. Auto Filtering macro - Changing activate cell
  217. 2007 Interface Upgrade Rumour
  218. how to code a lookup with 2 more or same data
  219. Transpose rows and column with condition
  220. Dialogue box to select folder >files for import?
  221. Protect my coding
  222. How to collapse Data into one line (similar to a transpose, but not quite)
  223. Retrieve data in the 3rd row inside a single cell
  224. Hiding Rows based on Drop Down menu selection
  225. Progress bar
  226. inserting hyperlinks using vba
  227. Concatenate rows and count them
  228. Trying to find only cells with text.
  229. Filling in a column based on certain criteria
  230. Excel Freeze Up
  231. Trying to do TextToColumns
  232. Combining two VBA projects – Error
  233. Copying and pasting multiple text files into different tabs.
  234. Workbook_SheetChange evet Macro not working
  235. calculated fields in pivot table
  236. Printing Pages with Macro
  237. Auto Close Workbook if inactive 5min
  238. Dynamic Range for Pivot Table
  239. compare and replace multiple values in excel
  240. promt warning msg if value in cel "" is below value in cell ""
  241. Tracking changes to find problem
  242. Auto-Sorting Dynamic Data
  243. Why does the recorder select and not activate a cell
  244. Macro To extract Data and place into template
  245. Macro to print page if data in specified cell
  246. understanding how FindFirst works.
  247. How do I sort a range of cells and then loop through the sorted cells
  248. External file
  249. Update of worksheet using macro
  250. Generating consecutive number every time a file is opened