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. Removing highlighted rows in Excel
  2. Forcing merged cells to expand to show all contents
  3. Copy values(rows & column) from one workbook from Another workbook
  4. Tranpose columns to Rows
  5. Prompt for VBAproject password
  6. Printing
  7. Mass extract table from PDF files to XL
  8. Problem in getting writing sql query output data to file
  9. Macro to delete all even rows through row 2000
  10. Browse Dialogue box from button on usrForm
  11. Cells containing zero
  12. macros pasting into next available cell of database workbook
  13. Change Variable data on 1 pivot table, make same changes in other pivot tables
  14. Textbox property change
  15. lookup find if copy in next blank cell
  16. Passing range data as VBA parameters
  17. Sorting between bold rows?
  18. To Extract any Word from Sentence
  19. using array function and vlookup to return values
  20. Once you write VB code, how do you run it?
  21. VBA and SQL Server
  22. Two into one function again
  23. Excel Cell in Calendar
  24. Making mulitiple cells required
  25. Fuction in conditional formatting interfering with other VBA code.
  26. Union Ranges and remove duplicates
  27. worksheetfunction.match giving run time error '1004'
  28. Stop text import at certain column?
  29. create a autonumber using macro
  30. How can I make an error message display when a required cell is left blank?
  31. Inconsistant Behavior using a UserForm
  32. Macros Dialog Box
  33. SQL Query in ADO not working
  34. salesman report
  35. Creating a Function in Excel
  36. Find first and last name on a cell
  37. VLookup maybe?
  38. Create a pivot table in a macro
  39. How do I make solver stop?
  40. VBA to mail in Outlook
  41. Taking data from varied length lists.
  42. VBA conditional formatting a range
  43. Ranges - list of all possible combinations
  44. excel to notepad
  45. Count visible, hidden, veryhidden sheets
  46. Combo boxes
  47. arranging data using VBA
  48. I can't make my calendar unload to a specific Cell
  49. Need to open the other file
  50. Check if file may be saved with this button
  51. text search insert a row on a second worksheet
  52. Checking Files Exist
  53. Excel executables
  54. Writing cells using Range() slows down with successive writes
  55. import data from internet
  56. VBA - Insert data into another workbook
  57. Call Function problem
  58. Checklist averaging using checkboxes?
  59. Extract Data to New Sheet with Red Color Cell
  60. Changing Cell colours
  61. ComboBox Object Size
  62. VBA code for lookup
  63. Conditional Formatting on a wide scale
  64. Identifying changed rows
  65. input data in my master list, and automatically have each site appear in it's own wor
  66. Copying photos based on a lookup table?
  67. Formula to add multiple vlookups
  68. Delete sheet's code
  69. Code to stop a WAV file
  70. Determine Active worksheet name
  71. VBA function
  72. execute macro after pressing enter
  73. More efficient way to format a column?
  74. source for combobox on userform
  75. Excel 2007: Programming the "Quick Access Toolbar"
  76. assigning multiple macros to a check box
  77. help with pivot table
  78. Find/Replace, then Copy Paste
  79. Auto pop-up after conditional formatting
  80. Auto password
  81. Import rows of data based on vlookup value
  82. 424 Object Required
  83. code to copy data from dif.cells in a sheet to a single row in another workbook.
  84. Creating Excel Buttons that Activate Worksheet
  85. calculatin dates - subtract a fixed date from todays date
  86. Very Hidden Sheets on Open
  87. Date Overun Alert
  88. Combo boxes
  89. Selecting a range with relative reference
  90. Dynamically link to control via module
  91. Macro that fills in cells needs to skip 2 rows
  92. Average a selection of cells where some contain #DIV/0!
  93. Merging multiple workbooks together
  94. Grouping unique cells,
  95. Matrices question
  96. 1004 Error
  97. import the internet data
  98. Automatically checkling ranges and selecting contents based on a value
  99. Best online resources for learning Excel Macro and VBA
  100. Run-time error '1004':
  101. how to check who opened the file in Excel 2007
  102. exporting -preserving zeros in excel
  103. How to exit sub
  104. Add a button to a message box?
  105. Make one particular worksheet read-only
  106. Trying to populate cells with data
  107. Any good VBA training courses in New York City
  108. Trying to run on every worksheet automatically
  109. Expected Function or Variable Error !!
  110. declaring a variable explanation
  111. Variable to retain its value for other modules
  112. Mid function to return part of String
  113. File List
  114. contact email button
  115. sort data on multi sheets before creating mastersheet
  116. Find & Replace
  117. Message Box - Idle after 5 mins
  118. Format Raw data as required!
  119. Initialising a frm from within another form?
  120. Auto date and time stamp
  121. Fill in a series of boxes on separate pages.
  122. Evaluate constant text formulas
  123. Toggles
  124. Macro to move chart range each time one row down
  125. Counter on a List Box
  126. Checking for excel version number and excel object version number when opening?
  127. Copy worksheet template using command button
  128. tab delimited formatting
  129. Referencing same cell on different worksheet
  130. Assign a macro and pass an argument
  131. Checkboxes and the IF function
  132. Need to set a "dynamic" linkedcell function to spinner buttons
  133. Capturing Status who have opened the file
  134. Opening Flies
  135. Hide & Unhide columns in Protected sheet
  136. Generate auto weekly report
  137. Formatting the Expense Re-imbursement Form!
  138. select product checkbox appear
  139. Runtime loading of DLLs
  140. code for saveas
  141. Delete Rows Based On Color
  142. Copy sheet without objects
  143. VBA script to pull "ZEstimates" from Zillow.com
  144. Parse out duplicates with specified value
  145. 4 Standard Deviations
  146. create userform
  147. find the number of last row with data
  148. parsing excel data to flash cs3
  149. best 20 results to obtain the highest average
  150. Delete sheet warning - Excel 2007
  151. Multiple cells from Multiple sheets
  152. Enable ComboBox - userform
  153. Calculating Date
  154. Variable time period/cell reference
  155. Make code more efficient
  156. Macro to calculate monies lent out
  157. Paste formats from row1 to all rows with data
  158. printing selected rows
  159. Odd macro results
  160. tab order in forms
  161. Aging Function
  162. Macro to populate a cell and then execute another macro
  163. Customizing Outlook with attachments!
  164. Create input boxes
  165. New Spreadsheet Guidence
  166. OCX Problem
  167. Protect a workbook
  168. worksheet listbox menu
  169. Add-In (which .NET version?) EXCEL.EXE.CONFIG
  170. Flash Game In Excel Document
  171. Changing range name to new active cell
  172. Excel Problem finder
  173. ODBC- error
  174. Seaching a Single Column without Selecting
  175. goto type function
  176. Creating Command Button macros
  177. Copy and paste unique values to another worksheet
  178. Run-time error 1004 in Pivot Table
  179. Make user choose from dropdown
  180. VBA debugger puzzle
  181. Transfer data for each tick box
  182. Hiding workbook during Macro Exec
  183. How to concatenate a variable with a Range
  184. Suppress SaveAs Warning
  185. text to coloum
  186. [SOLVED] Creating a workbook menu for viewing/printing
  187. Combine multiple sheets into one
  188. compare all matches
  189. Macro for counting instances of text
  190. Text to rows
  191. Save file by cell value
  192. how to print worksheet automaticly
  193. Code to use a varible integer inside a formula in VBA
  194. Textbox / label names
  195. autosaving
  196. Close workbook using range value
  197. Comparing two named ranges and placing matches into third range
  198. incorrect regional date in Excel
  199. Empty a textbox when selecting it
  200. Another 1004 error problem
  201. Possible to format the body in a mail using SendMail?
  202. Got my nested "For" #& "IF" in a bit of a muddle
  203. Open protected workook with VBA
  204. cell adjacency test with CountIf function
  205. Graph tweaking
  206. date formula
  207. Digital clock on excel
  208. Hide sheets until a "disclaimer" is clicked on the front sheet?
  209. Protect a workbook, but still allow Autofilter function to work?
  210. exporting data to Microsoft Word
  211. Excel EOD Metastock Format Convertor
  212. Sub "SelectionChange" vs copy&paste
  213. Increment counter so when Button pushed, get new sound message
  214. new to Macros; automatically run autofilter?
  215. Macro for selecting new worksheets
  216. Change Picture lookup
  217. Paste Special Value macro causes PasteSpecial method of Range class failed error.
  218. Duplicate data in the same column
  219. Point Code to Specific UserForm
  220. need to iterate, or something...
  221. Application.FileSearch in 2007
  222. Checking if data changed on a worksheet
  223. Creating a range of dates
  224. Remove unfiltered rows of a customview
  225. Moved Userform Controls Don't Work
  226. Designating a workbook
  227. Find last row not working
  228. searching only part of the values in a cell
  229. macro execution
  230. import data from .txt file selected by user
  231. Constant in PivotTable
  232. how to store UDT into dictionay
  233. userform combobox list link to sheets of different name
  234. Pasting a formula that contains "" using vba
  235. Replace function
  236. Use master list to find entries in another sheet and add corresponding text
  237. field copy
  238. Automatically populate data
  239. Using a macro to draw borders
  240. Make a cell mandatory so that user can't navigate away from sheet until its populated
  241. Lookup results from anouther worksheet and display specific ones
  242. Confirmation Pop-Up?
  243. Password protect macro button??
  244. path computer name from value of lookup
  245. add a row and insert a name alphabetically in a range
  246. macro inside command button and combobox
  247. Deleting rows based on criteria in reference worksheet
  248. Exporting a selection to a text file using a filename specified in a cell?
  249. VBA Code to Add Event to New Worksheet
  250. connecting different sheets