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. Lost toolbar paste function
  2. Macro to Copy from Excel to Word
  3. creating named range in workbook that refers to VBA range
  4. Error on Columns("B").Width + x
  5. Copying data from Auto Filter
  6. [SOLVED] Trouble with .Formula
  7. Rearranging data to better perform in a pivot table
  8. Search Sheets and Show results
  9. [Solved] Evaluate Function
  10. goto statements
  11. [SOLVED] Automatic custom filter on dynamic data
  12. Visual Basic Editor reference?
  13. Macro refresh to different cells
  14. [SOLVED] Macro to Insert Column Heading to all Worksheet
  15. Macro for Add Column Header to All Worksheets
  16. Select range of unlocked cell
  17. copy of some cell details to other sheet
  18. Using a vb formula for each row
  19. [SOLVED] Search and replace
  20. Scroll Bar Positioning Relative to Cell
  21. [SOLVED] Can I open a file by searching for first six characters?
  22. set range in another workbook
  23. [SOLVED] Sort / Filter rows
  24. Combining Data from multiple sheets, plus tracking?
  25. Page Breaks
  26. [SOLVED] Delete VALUE! error
  27. [SOLVED] BeforeSave Event Problems
  28. Data transfer between two sheets based on condition
  29. [SOLVED] date update
  30. Recursively search a sharepoint site for xls and xlsx files
  31. Macro to close excel
  32. auto change text
  33. [SOLVED] Spin button event handling
  34. Solution Quality Index
  35. [SOLVED] Macro to cut and paste with a snag
  36. Finding Range of Data.
  37. 'Exporting' contents of Locals Window
  38. VB Code to show Define Name
  39. Executing a macro
  40. Selecting all charts
  41. Check name against different spellings list
  42. [SOLVED] Property of tabbed panel
  43. Text manipulations
  44. [SOLVED] open file and text import code
  45. paste a shape based on cell value
  46. Error occurs, excel closes when running macro?
  47. [SOLVED] End right Skip Blanks
  48. Workbooks.Close not working?
  49. copy+paste nested formula ??
  50. Macro does not run in a shared workbook
  51. [SOLVED] Macro to effect cell based on column
  52. [SOLVED] Copying data VBA
  53. Run-time error 438 when trying to update a closed workbook
  54. [SOLVED] Populating a multi-dimensional array
  55. [SOLVED] Text to columns VBA code to change delimiter if the cell value is in array
  56. [SOLVED] Code to Filter, Sum and return a value from data set
  57. Compare the data using VBA/Macro
  58. IF true then Exit sub ?
  59. [SOLVED] Bad Read-Only Error
  60. VBA Compare date in cell A1 to VBA now()
  61. Userform and Access
  62. Create new row on new sheet IF conditions match
  63. [SOLVED] Passing Boolean Variable To A Function
  64. [SOLVED] Opening files with only part of the name
  65. VBA to open a password protected workbook
  66. script help!!
  67. VBA Pivot Creation Works Only Sometimes
  68. [SOLVED] dimensions of a graph
  69. Web Query (Table Cell Isolation)
  70. VBA Charting Data with ComboBoxes and Date Pickers
  71. [SOLVED] Passing a private variable to another module
  72. [SOLVED] Unable to record error, long formula macro problems
  73. select sql row with locks using excel
  74. Expiration of project
  75. [SOLVED] Creating New Tab Syntax Error
  76. User Defined Function MAXIF and MINIF
  77. vb adodb connection passing value
  78. [SOLVED] User Defined Function Description
  79. [SOLVED] Insert Text into Cells after New Tab Created
  80. Adding another highlight function to my code that matches lists
  81. [SOLVED] Filtering Macro
  82. Named Ranges In Custom Functions
  83. Change text in cell based on criteria within that same cell.
  84. Bisection method
  85. Translate ~Number of days in a week to number of days across months
  86. Excel Worksheet Tabs
  87. Insert New Name/Row/Alphabatize Into excel
  88. Class with property as collection of another class
  89. How to select Chart on sheet and set secondary axis scale
  90. [Solved] HELP! Continuous loop, can't exit can't save!
  91. update an overview sheet using a command button
  92. [SOLVED] How to use iserror to replace #value!
  93. [SOLVED] IF/Then/Else Syntax Problem
  94. Stock macro/cell reference ?
  95. Howto keep control of an option button after multiple instances
  96. VBA to save URL pages
  97. VBA - Custom Filter
  98. Automatically Consolidating Multiple Sheets
  99. [SOLVED] why this code isnt working?
  100. Repainting a cell in Excel using VBA
  101. [SOLVED] how to input formula down large s/s??
  102. VBA and ADO
  103. Adjusting Macro
  104. [SOLVED] Autofill macro: filling for range whilst there is a value in cell
  105. fill down empty rows
  106. Data transfer between two sheets based on condition
  107. Formatting a Cell within a function
  108. [SOLVED] Setfocus question
  109. Ranges of cells in VBA
  110. [SOLVED] Copying data from Spreadsheet to List Box in a UserForm
  111. For each...next statement
  112. Find part of text within cell and replace from another cell
  113. [SOLVED] Sorting items in a table
  114. Excel Programming
  115. Conditional IF Statements in Same Cell
  116. Delete Rows After a filter
  117. Query work in access 2003 BUT not when using VBA in Excel Cell
  118. [SOLVED] Macro quitting before completion
  119. If...Then Loop. Copy row into seperate workbook.
  120. formula needed
  121. Help with code!
  122. How to iterate angle values between 0 to 2pi
  123. Export Marked Data to Word by Date
  124. graph on the push of a button
  125. Add users' Initials to the footer
  126. [SOLVED] New Excel Tabs using Text Boxes
  127. applying formula and formatting to group of cells in a macro
  128. Splitting excel file up by 100's
  129. [SOLVED] Hyperlink to workbooks in a folder
  130. [SOLVED] How to select unique rows and count in excel
  131. How to separate cells with more than one name in them, and add a new row per name?
  132. selecting only certain rows based on other columns' rows!!!
  133. [SOLVED] remove data in parenthesis
  134. [SOLVED] Define when a user selects specific multiple cells
  135. [SOLVED] Need correct syntax for ranges
  136. [SOLVED] Same script running in two workbooks with different results.
  137. Excel Shift Entire Row Down VBA
  138. Match imported data to list
  139. Using inputbox to insert multiple numbers into formula
  140. Autofit to a cell
  141. Return VBA Created Range
  142. auto numbering with non uniform gaps
  143. [SOLVED] Check for a named list
  144. number of months between two dates
  145. [SOLVED] Unable to save external link values.
  146. [SOLVED] Need help with Print Button Macro
  147. creating a macro in the toolbar
  148. Making 1-D Array Into 2-D When Using Split to Output to Sheet
  149. Goto a named range/cell
  150. Copying a cell colour - and use the format in a different cell.
  151. [SOLVED] Concatenate with carriage return- how to remove blanks?
  152. Turky and Fischer LSD
  153. creating all possible combinations
  154. [SOLVED] Scrollbar in a dropdown list
  155. [SOLVED] Exit sub is deactivating all other macros
  156. import data from outlook
  157. Macro to run when worksheet clicked
  158. Select part of Column next to ActiveCell
  159. Cycle sheets & copy color coding
  160. [SOLVED] Excel Fill Color Change with Range
  161. search and copy macro
  162. Format and Total Macro
  163. [SOLVED] Continual Changing Sheet Names
  164. Macro to insert new row where I choose
  165. How to delete data from worksheet
  166. [SOLVED] linking graph data to active workbook
  167. [SOLVED] insert a blank new row if check the different content in the next row
  168. VBA code. Save then email and then delete saved spreadsheet.
  169. Exporting to new workbooks by column values
  170. [SOLVED] For Each Loop Run time error
  171. Insert into all cells macro
  172. Excel VBA Move File After Import
  173. checking contents of upper cell
  174. finding soonest date depending upon value in another column
  175. VBA To Bring Up Specific Type Of Dialogue Box
  176. doctype declaration issues in xml
  177. Delete Rows After a filter
  178. [SOLVED] Copy cell contents and all formatting
  179. Force Excel to direct user to a specific worksheet upon opening
  180. [SOLVED] Send workbook via email to multiple recipients
  181. Simple Array Problem
  182. [SOLVED] Scroll Bar to change Percentages
  183. Textbox Linked Cell
  184. Automated Search and Replace using a list
  185. [SOLVED] code stops working after X rows.
  186. [SOLVED] Capitalizing the first letter of every word in a cell, without changing anything else
  187. Inefficient code
  188. Distributing one column amongst multiple columns.
  189. [SOLVED] Match not working
  190. [SOLVED] Open Link from separate worksheet
  191. Link two dynamic workbooks with multiple tabs
  192. Autoselect Cells Based on Cell value
  193. Application-defined or object-defined error on an ActiveCell
  194. [SOLVED] Macro or function to graphically map out cell precedents?
  195. Macros in 2008
  196. Mappoint totals
  197. [SOLVED] Password protecting a user form
  198. Case Study Start up
  199. Autofilter question
  200. Re-ordering some columns (groups of columns)
  201. Excel and Python
  202. [SOLVED] multiple iF statements
  203. Prep for new day/data
  204. [SOLVED] Log time on worksheet when userID and pw is correct
  205. SOLVED:Selection order of Option Buttons
  206. maximizing file upon opening
  207. [SOLVED] Using VBA to Update
  208. [SOLVED] copy from one column and paste to another column by (alt + enter) function
  209. [SOLVED] pop up a userform to ask user to key in data based on the keyword
  210. Auto-short & Ignore blanks in Drop Down Menu
  211. User Defined Functions
  212. [SOLVED] Hide or unhide columns with one macro
  213. Yet another call macro question
  214. Can't open up excel file after i did a marco
  215. Move data to cell sheets
  216. Making a Spreadsheet that works like building a computer on Dell.com
  217. sorting a column with calculations
  218. Setting Range based on LastCell
  219. Deleting data using macro
  220. Do While Loop
  221. [SOLVED] Macro for sorting alpha-numeric data
  222. 64K Segment Boundary: what is it and how do I avoid it?
  223. VBA code auto load and auto closing
  224. [SOLVED] Hiding/Showing Rows With Combobox
  225. Running Total problem
  226. How to save data from combo box to userform1?
  227. Automate data from Web
  228. [SOLVED] Get number of pages of a different sheet
  229. EXCEL VBA Code returning wrong cell
  230. Opening sheet to LAST BLANK in range
  231. Making MonthView default to today's date or leave blank
  232. Auto Produce PDF
  233. Cut & Paste Macro
  234. [SOLVED] Learning VBA
  235. Macro for taking a file from folder of previous day
  236. [SOLVED] Excel and SNMP
  237. If then macro/scenario fullfilment
  238. [SOLVED] Macro Removes Formula
  239. change multiple pivot tables on 1 sheet
  240. Shortening copy and paste code
  241. problem with CSV output
  242. Autosave backup, that stores files by date in specific folder.
  243. Save As and Creating Directory
  244. Delete repeating heading rows
  245. [SOLVED] Monving Macro From PERSONAL.XLS
  246. How to copy an outlook form to Visual Basic
  247. macro to transfer data between two columns with a condition
  248. [SOLVED] Selecting Cells based on last used column in lower row
  249. Macro to copy same 3 cells repeatedly
  250. VBA for combination