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. Delete Last Line
  2. Compare Macro
  3. Windows Task Scheduler Question
  4. match not found - message
  5. if value exists
  6. Macro - Logical Order
  7. return worksheet names that do not meet criteria
  8. How-to: Toggle the button face on a custom toolbar?
  9. DIR function in excel, opening multiple files.
  10. cell to textbox vba
  11. Create Hyperlink to another worksheet within the entire worksheet?
  12. macro to paste in the next available cell
  13. reset cells button and creating a pop up box
  14. Macro to Delete Last 11 Characters in each cell in column 1
  15. Importable macro for use with any open workbook
  16. Last Row VBA ignoring formulas
  17. Highlighting Protected/Unprotected Cells
  18. Protecting/Renewing Conditional Formatting on Unprotected cells
  19. Conditional formatting for more than 3 conditions in different worksheets
  20. Data Validation on Text Box inputs
  21. Open a word file
  22. Controlling print settings using Excel macro
  23. Getting data from HTML page to XLS
  24. User-Defined Function Update
  25. Code For Results
  26. Delete with shift causes cells loose fill & border around
  27. Selective Summing Macro
  28. office 2003 and office 2007
  29. File name prevents code to execute
  30. extract string of text
  31. From Worksheet To List Box !!
  32. Run-up Analysis Calculation
  33. Hyperlink To Another Sheet
  34. expanding code?
  35. Hiding Custom Views from end-user
  36. Selecting and Copying a Cell or a Range of Cells from One or More Files or Worksheets
  37. macro not running if cell conditionally formted
  38. copy range to array after hiding rows
  39. How? Excel send text Msg to peer/peer vbnet users without server
  40. Code to Copy Data From one Worksheet to Another
  41. Importing data through Visual Basic
  42. Converting text to numbers
  43. VBA Array question
  44. Remove a cell's text & leave a number in it.
  45. Find and Replace
  46. macro to delete a read-only file from a folder
  47. Simulating autolist on userform
  48. Best option for Html
  49. Third Party Data - Import
  50. Macro to sort between two rows
  51. paste link vba code
  52. huge text for email!
  53. Call a label of another sub in same module
  54. Conditional Formatting
  55. Running macro in different workbook
  56. File Contains to be Unique
  57. Optimal Portfolio Macro/Program
  58. Running a macro from an IF Function in excel
  59. Ranges & SetSourceData
  60. Macro for selected/unselected checkbox?
  61. trouble protecting vba in 2007
  62. Macro code to change cell range to named range
  63. compare and replace text (translating language file)
  64. Closing the workbook & saving automatically
  65. Advance LOOKUP !
  66. error message?
  67. error message?
  68. Keeping formula in Cells after "data refresh"
  69. macro to separate data
  70. All combinations of 1 and 2
  71. Conditional Formatting on Every Cell in Every Row
  72. launch another application
  73. Row number as variable?
  74. Delete rows based on values from worksheet
  75. Week to date figures calculated on external spreadsheet?
  76. code to run when creating code from a template
  77. VBA Error 400
  78. consecutive sheet name
  79. Web publishing resolution change???
  80. correcting macro using comments with protected worksheet
  81. Excel 2007 - Record Macro not Capturing Everyting
  82. If statement not working
  83. macro to lookup data and copy and paste
  84. Inserting a formula into multiple cells
  85. Macro needed to Identify a data skip and add a space
  86. Refreshing the screen/making objects invisible?
  87. more copy and paste
  88. Run a macro.......sometimes
  89. Lookup Function thats copy and pastes data into another sheet
  90. Re-arrange Data
  91. Updating The worksheet on click.
  92. Add Values to Combo box
  93. importing text files into excel -fastest way
  94. Keep Modal UserForm Alive after closing 2nd userform using 2007?
  95. Random Numbers
  96. Renaming Objects in TXT File
  97. Deleting Range
  98. Show only values over 0
  99. Error 1004 after protecting worksheet
  100. Link macros to xla file
  101. conditional formatting weeks
  102. Return to previous sheet
  103. Renaming objects upon pasting them through VBA code?
  104. Call sheet procedure when print is clicked.
  105. custom number formatting.
  106. Group/ungroup columns in protected sheet
  107. Advanced Search using Userforms?
  108. Array - from a list in a sheet
  109. Copy 5 sheets to new workbook with dialog form where to save
  110. Price Allocated To Name In Drop List
  111. Adding Auto Comments
  112. Row Number of Current Cell - within a Function
  113. Naming a series collection
  114. personal.xls is not working on office XP
  115. Application object methods not working
  116. Copying file name
  117. Conditional Formatting Code
  118. Macro - Transferrable
  119. How to copy a cell into a range that will differ each time-
  120. Copying values (in VB) from multiple file merge
  121. auto web update/interaction
  122. Edit code to fill range
  123. Trying to run macro based on checkbox selection
  124. Copy Data to Specific Sheets
  125. autofilter and macros
  126. Loop EOF errors
  127. hiding worksheets
  128. Non repeated use of items in a lookup table?
  129. Creating facotrial lists???!
  130. Pressing any key in any textbox clears a cell?
  131. Saving Workbook in specified location, but as read only and compressed!
  132. Timesheet miscalculation
  133. If statement
  134. Summing values of a column
  135. For each to loop through columns
  136. Exporting to Excel
  137. Making columns background color change
  138. Combo Box
  139. Formatting E Mail Body Text
  140. Excel Line Chart - 12 month chart moving with dates
  141. ERROR: Microsoft Office Excel has encountered a problem and needs to close
  142. VBA for search/find
  143. Excel VBA - Advanced Filter Variable Cell Reference
  144. Renaming Sheets
  145. AutoFilter - Selecting On Both Sheets?
  146. enable autofilter/ expand collapse
  147. UsedRange
  148. Copy paste from one worbook to another workbook
  149. problem with this protect/unprotect macro
  150. Sheet Macro for Preventing Paste Not working
  151. Home made icon buttons
  152. Using VLookup in 2 cells without losing it when the value is changed in the other.
  153. Excel Macro that searches open workbooks
  154. How can I open a protected file?
  155. Dynamic Macro
  156. alpha/numeric cell address
  157. controling the page filed of a pivot table Programatically
  158. Return Row Number?
  159. pass querystring to Excel
  160. email worksheet rather than workbook from macro
  161. Use Excels Analysis ToolPak in Outlook
  162. LIKE function in macro programming
  163. How to create a table in the Excel footer?
  164. Automate a add-in process
  165. Formula Error
  166. To The Forum
  167. YTD tally of multiple values that are reset daily.
  168. Programming Named Ranges
  169. Transpose worksheet
  170. Password Protected Formula Bar
  171. Message box
  172. If Condition for macro
  173. Merge cells which contain the same data
  174. Force a selected cell/range to display directly under the freeze line
  175. Row / column selection syntax
  176. Find last cell with data
  177. code to change text colour
  178. Problem Copying Code
  179. Excel Macro - Read excel & read excel range - save as text
  180. Do while loop? Then paste to another sheet
  181. macro to write "running" numbers
  182. Problem with simple macro/VBA code
  183. clear contents
  184. Fetching contents of cell based on input
  185. Excel Help
  186. automatically move left one cell after data input by scanner.
  187. UserForm and Pasting Information
  188. Copy & Paste a row underneath the last one in the table
  189. IF Formula Help Required
  190. interpolation formula
  191. Code to Copy Data From one Worksheet to Another
  192. Worksheet_Change or selection_change
  193. ShowLevels Event
  194. placement of code to dynamically hide code
  195. Copy multiple cells from several work books to one workbook
  196. SUM Formula Erring
  197. [SOLVED] saving worksheet in html format office 2007
  198. Unviewable Yet Useable Macro
  199. Protection compatibility issue 2002/2003
  200. increasing cell value with a variable
  201. macro-random number
  202. Create new worksheet based of duplicate records
  203. Can't create macros in Excel 2007
  204. Displaying frequences.
  205. Hidden and visible sheets-swap
  206. Anyway to paste past hidden rows?
  207. thai calendar year
  208. Macro to delete the entire row
  209. Copying Data to Specified Sheet in another Workbook
  210. Pop-up Calendar When Cell is Clicked
  211. comapring columns
  212. Adjust Zoom for Sheets
  213. Thanks for all the help
  214. adjust lastrow In Col to a height of 7.5
  215. Lookup formula
  216. open workbook with particular sheet
  217. How to create buttons?
  218. Pop Up Msg
  219. Reference Range for Sheet Names
  220. Warning msg before macro is activated
  221. Printing Macro
  222. Copy Paste Special Values
  223. Getting Web page source (HTML or XML) in VBA?
  224. copy data of check box is clicked true
  225. Two cell accumulator then reset first cells
  226. edit code
  227. How to create own category for my udf's?
  228. digit 1 mean extra digit 2 mean normal
  229. Dynamic Variable Name during Runtime?
  230. Lock range of cells dependant on date range
  231. Pull down in a pull down
  232. Howdo I delete duplicate data
  233. Moving over 1 cell (column)
  234. Excel RTD Question - UpdateNotify
  235. executing an exe file from macro
  236. Using folders in the VBA Project Explorer
  237. 2003 to 2007 commands that changed
  238. right clicking to make check marks
  239. Calling SubRoutines
  240. Code for a Clear Form Button
  241. Killing a particular instance of Excel
  242. Conditional based on letters
  243. pause for selection
  244. Lists
  245. Date picker
  246. debug error?
  247. Copy Complete Worksheet to Text File Tab Seperated
  248. chart when recoreded plots differently than when run as a macro
  249. Is there a way to have cell equal to autofilter?
  250. Reference a different workbook