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. Text to Columns dilemma
  2. Create new worksheet when team name breaks
  3. Cut & Paste macro
  4. comparing two lists for matches
  5. New question about exiting a loop!
  6. Find & replace
  7. A macro that runs if the date is x
  8. Excel 2007 sheet activate
  9. exclude minus figures?
  10. Renaming dynamic cells in an active column
  11. Autosort by date ...not alphabetically
  12. Chart Data
  13. Copy Content in new row
  14. Message display outside spreadsheet?
  15. Codes for transpose/copy to another worksheet
  16. Passwords
  17. Run Auto_open only if file it's in is not a particular name.
  18. Copy/paste data into last column
  19. macro to create a new tool bar, add a custom menu item, name property & assign macro
  20. Run a macro on cell entry
  21. Formatting
  22. Store name as variable
  23. Cell Formula from Current Cell
  24. Unique Auto Save
  25. Quick and Simple Cell Shading Code needed
  26. Running a VBA app when a workbook is opened
  27. All combonations in separate cells.
  28. bring up a userform that searches
  29. disable delete
  30. msgbox apear if macro clicked
  31. Save file as CSV
  32. File Resize
  33. Fix button position
  34. Word equals charecters in different cell
  35. Typing in another program
  36. deleting sheets in a macro
  37. Macro that will copy Rows from one sheet to the next
  38. Copy all cell values in a column into another column's cells comments
  39. "go to" tab function with excel
  40. Indirect reference to closed workbook
  41. Undo after macro
  42. Declare Several Variables in a row easily
  43. build userform for find
  44. sumproduct issues
  45. Phone Format - change value.
  46. check box is clicked and click ok will call macro
  47. Close File At Park
  48. VB method to Reset picture size
  49. Not recognising two values are the same
  50. Highlight B2 in each worksheet on exit of Excel
  51. Refering to a checkbox on a worksheet
  52. Read data and separate into different worksheets
  53. suggest correct spelling
  54. Hide row if cell is a certain value, with unhide toggle option
  55. Macro SOMETIMES doesn't work
  56. Saving Workbook in specified location
  57. picture change according to text
  58. Create new sheet based on cell value
  59. Boolean operators
  60. Distributing an update
  61. Transfer data to FoxPro Table
  62. Copy data based on cell value
  63. copy and paste value using macro
  64. contains (if query)
  65. showing parameters on custom built functions
  66. search and select rows on user entered text
  67. Database Refresh and Copy/Paste in a Macro
  68. How to change "#DIV/0!" to 0
  69. Compile Error
  70. Macro to grab external data and paste values into a master spreadsheet
  71. count up to the next blank cell
  72. a macro that craete another macro??
  73. Userform Woes
  74. excel formatting using dos
  75. Check for increasing numbers 7 times in a row
  76. PasteSpecial
  77. Coverting Multiple columns of data into 3 columns
  78. Range Selection on filtered table
  79. Macro to move cell if...
  80. Combining frequencies of one column of data
  81. UserForm_Initialize screen update
  82. Using Range in a Macro instead of Cells(R,C)
  83. Create new worksheet based of duplicate records
  84. Sorting,Suming, Moving
  85. Web Query Import to a single cell
  86. Round to the nearest 9
  87. Copy Cut Paste by Certain Value
  88. How to open Hidden rows
  89. Notify me of any changes in workbook
  90. Oracle recordset to Excel
  91. opening two files simultaneously
  92. Exiting VBA to a chosen cell
  93. Restrict others to edit and see the formulas
  94. 1004 general ODBC error office 97 windows xp
  95. data searching
  96. Get File Properties
  97. Too many Conditions for Conditional Formatting
  98. The power of Excel????
  99. individual formatting cell in a range
  100. Sendmail brings up Internet Connection Wizard?
  101. delete certain charachters
  102. Date colour change in a range
  103. macros
  104. userform with lebel name as in sheet1
  105. Preventing save
  106. Auto sum + sheet protection
  107. How do I rename multiple sheet sets?
  108. Message Output
  109. Run macro everytime cell content changes
  110. email range
  111. Filters
  112. Function $ postfix
  113. sorting problem
  114. Autofill Range offset by 1 column
  115. unicode file conversion
  116. Insert parenthesis
  117. problem with function ranges
  118. Auto Saving File to Folder with Current Date
  119. How to remove from column B if it also exisits in column A
  120. Find text in ROW 1 and select corresponding column
  121. A button that opens a new workbook and saves the current worksheet on to it
  122. Chart Copy from Workbook to Workbook
  123. Restricting Paste Function
  124. Clean an exisiting excel sheet
  125. Correct an unwanted split in csv file
  126. Auto save of csv download
  127. Create a find/ search field w/ userform?
  128. Set a Displayed Value and a Stored Value for a cell
  129. Assign value to a string based on its position in a list
  130. Descriping excel udf functions
  131. How do I delete all rows containing a certain (variable) text string?
  132. Strange Texttocolumn behaviour
  133. combining codes
  134. Excel VBA MSForms ListBox Issue
  135. how to make a pop out box which shown "invalid value"
  136. Linking Object Size to Cell Value
  137. Emailing form Excel Using VBA
  138. Dynamic Ranges....
  139. QueryTable update
  140. VBA code to change value in a drop down
  141. Move image to further right hand edge!
  142. Finding and deleting duplicates across two workbooks?
  143. View form on protected sheet
  144. Select certain cells in active column
  145. How to format text when sending mail to Outlook?
  146. Creating Autoshape Macro
  147. Problem with my formula which require variable extract from steam table.
  148. Macros paste problem
  149. Problem with quotation marks
  150. Select visible cell using Offset
  151. link to filldown
  152. How To Disable The Macro Button??
  153. Coding numbers to letters
  154. How to remove duplicates from a column
  155. Sorting In WorkSheet Based On First Two Digit..
  156. Problem with variables
  157. Using Range in Worksheet_Calculate
  158. Rename a workbook and save to another location
  159. Looking for advice / suggestions for creating web queries to populate table
  160. Logon ID
  161. User Forms
  162. Auto_open macro using an "expiration date" to disable the spreadsheet
  163. VBA MsgBox
  164. Conditional format for VBA
  165. sorting macro
  166. Function to return boolean if activeworkbook name has specific text
  167. Responses hampered by site malfunctions...??
  168. Using VBA to add people to a table using form
  169. Lookup in multiple sheets
  170. Load items in combobox
  171. Button to link to PDF File
  172. Auto Save Every 5 Minutes
  173. Conditional Format cell with #N/A
  174. paste in the multiple of 33
  175. Extract data from word document
  176. Copying Values to another worksheet based on day of the month
  177. Selecting worksheets in a workbook based on criteria
  178. random the name
  179. macro to delete data from cells in all worksheets but 2
  180. Radio Buttons
  181. correct many macro modules
  182. enhancing Column A through Column B
  183. Macro: delete row any time column A is blank cell ?
  184. calling sub from another userform not allowed, even after making it public
  185. enter kerr542 every 20 lines
  186. Search and delete records
  187. schedule the marco to execution
  188. Problems with listbox
  189. Modify macro to count colored cells
  190. Running same VBA over multiple sheets
  191. find Non-blanks and offset value
  192. Multi Function Macro
  193. Why do Macros work sometimes?
  194. Subtotal according to changing number of columns
  195. defining a years length(start and end dates)
  196. Dealing with Worksheet_Change...
  197. CELLS.Select method failing
  198. Populate cells from an import
  199. searching variable in the spreadsheet
  200. combine code
  201. Auto numbering and workbook log
  202. lookup function?
  203. how to do Comparision of two dates vba code
  204. Copying from closed excel files
  205. macro times out computer
  206. ATS data sampling frequency question
  207. Preventing duplicate entries
  208. Return All Results from a Loop-Function
  209. Auto-naming tabs in a workbook
  210. Code shrink
  211. Macro to save a form.
  212. How do you Show/hide headers in OWC11
  213. Excel VBA: Hide Sub Total Warning
  214. Formula troubles
  215. Getting a macro to staple printed worksheets together
  216. Macro to insert new row in protected worksheet
  217. Annoying currency problem
  218. Vba 101
  219. Real time question
  220. Excel Internet Interactiveness???
  221. Excel VBA books?
  222. A macro to create a form button, assign a macro and name the button
  223. Create a button to print a sheet
  224. Sorting cells with formulas returning a "sum">0 else nothing in cell
  225. Merging Cells With Duplicate Values
  226. Excel 2003 not autocalculating new formulas placed by VBA
  227. Auto-save macro with a particular day in the file name
  228. Solver VBA - Problem - How to rid of Dialog Box "Single Step"
  229. Closing Workbook without saving Changes
  230. Excel macro for retrieving file names
  231. Formula for data duplication between excel sheets?
  232. Excel form comboboxes to pulling data from access
  233. cell locking once filled
  234. Count highlighted rows
  235. disable spell check box.
  236. Trap SORT event?
  237. Run-Time Error 91 When Dynamically Creating Controls and Event Handlers
  238. Macro to delete all worksheets except currently selected.
  239. Copying workbook and saving to new file
  240. Open an existing .xls using a macro
  241. Insert Row Problem
  242. Design a macro for my project
  243. Date Picker
  244. If statement
  245. Changing the colour of an entire row from one cell, for any row
  246. Command Button Code to Add New Row to List
  247. creating and deleting sheets
  248. Changing the background colour of an entire row
  249. Many users in excel sheet at (almost) the same time
  250. Tabbing Problem when enters new box on user form