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. How to end sub within If Loop
  2. Commenting out parts of a Macro?
  3. Fill n rows with same value
  4. Combo box control an OLAP pivot table
  5. clearing combobox used in userform
  6. Array does not store value
  7. Sorting and copying columns (Forms)
  8. Color coding cells
  9. Add CalculatedField to PivotTable
  10. moving sheets using combobox
  11. How to assign a variable in a macro?
  12. Set PivotItem.Visible property dynamically
  13. Help getting String into Array
  14. Run code but carry on working
  15. Number of Copies - Printing
  16. Label Duplicates as 1,2,3 etc using macro
  17. Trying to create a dynamic formula in VBA.
  18. Paste Colored Cell Value in Range
  19. compare 2 worksheets & transfer cell colors
  20. Slight problem opening word document from macro
  21. search for Value between Dates specified
  22. Permutation of Text with Known Space
  23. Dependent Pivot Tables
  24. Prompt box on exit
  25. Return ColorIndex array
  26. Macro not Running Properly in Excel 2003
  27. different workbooks under the same "working" name
  28. InputBox Error.
  29. dynamic named range relating to cell values
  30. Macro To extract Data and place into another document
  31. Check if a list of Files exists Macro
  32. Find Values, Delete and Move Left
  33. Macro to move from one sheet to any other
  34. blocking entries with data validation
  35. PivotTable Not Showing Values
  36. Trying to build a macro filter based on data in either of two columns
  37. fromat date and time
  38. Exact match macro
  39. Radio buttons in IE
  40. Conditional Formatting different colours in cells
  41. Trying to insert rows dynamically
  42. making code more efficient
  43. macro that deletes rows that dont meet criteria
  44. Validate user input
  45. Copy Excel using Environment.Current Directory
  46. Macro to move one sheet to another book and create a new sheet in the original book
  47. user form - next step to get it on to a spreadsheet and working
  48. Version change causing unwanted behaviour
  49. Macro to open workbook, run macro, save, and close.
  50. Stop screen flashing
  51. Comparing values in Cells
  52. macros that adjust themselves with the addition of rows!
  53. Referencing between worksheets with Radio buttons
  54. Trying to design a Creche Enrolment schedule
  55. Color fortmatting
  56. Insert Rows Based on Location
  57. Remove HTML from Worksheets or anything between < >
  58. Problem With Personal :xls
  59. Macro to hide columns with no values in but still including text
  60. Getting Selected Cell Value into Macro
  61. Trying to pull the column index from my macro
  62. Find and replace macro
  63. Question about replacing Word text from Excel in many files
  64. I need a macro urgently, please help
  65. Userform Multipage Event Change
  66. Automatic Save by Date
  67. how to insert conditional language in a macro?
  68. Moving a Cell without have to change Code
  69. VBA Match or No Match
  70. VBA Strategy Question
  71. conditional formating to compare 2 time values
  72. running macro on time not working
  73. Percentage Calc
  74. Range Parameters as Variables
  75. Edit cells in row if one cell in row contains word 'yes'
  76. Exporting sheet as *.txt - Exclude Quotes Macro
  77. if macro for advance filtering in place
  78. Bold Text for Lotus Notes sent via Excel
  79. Repeating code
  80. Date syntax I should be using in the 'Value Field'
  81. How do you save the VB code so that it is independent of any workbook?
  82. Convert XML to Excel.
  83. Copy-Cut entire row that starts with a certain value/word
  84. Converting Latitude/longitude to OSGB grid ref
  85. Copying rows of data into different cells in a new worksheet
  86. Formula string vs. workbook function VBA for speed
  87. kill workbook if not opened on a certain machine
  88. Progression Display
  89. Standalone Compilers for Excel Workbooks
  90. ListBox Problem...
  91. Create new workbooks and worksheets from an existing Workbook
  92. delete entire rows based on a criteria
  93. Auto increment Invoice number on template by 1
  94. inserting rows..!
  95. Trades Reconciliation
  96. Sort Columns to tabs
  97. Programming something like 'LOOKUP'
  98. Prompt message of time limit when time is entered
  99. method 'range' of object'_global' failed
  100. Refering to Multiple Textbox on a form
  101. Avoiding "If" statements in macro
  102. How to apply Macro to a cell?
  103. bug in vba macro to create pivot table
  104. How do I run a forumla in a macro?
  105. Code running in wrong sheet
  106. Lookup and add to existing values.
  107. bringing up the data -> form... box via macro
  108. No "Enable Macros" Prompt
  109. Scrolling and freeze panes
  110. Is there a way to program Excel to do the following?
  111. vba to autocorrect date every week
  112. Row Height with Links
  113. Macro to readoff combobox
  114. Run macro on time
  115. determine if new row has been inserted in worksheet
  116. Conditional Format
  117. Selection Macro Help
  118. Can't 'Undo' with VBA macro running
  119. Read only
  120. Search multiple sheets for unique value
  121. Check Boxes in UserForm
  122. All Macros Deleted After Using One
  123. Coverting a spreadsheet
  124. "No Fill" for cell's interior = -4105 or -4142 ?
  125. How to Learn VBA?
  126. Problem with delete empty cells
  127. VBA to copy data in worksheet
  128. macro runs the wrong macro
  129. Find and Compare
  130. Copy rows of data into a different format
  131. Macro to copy a range of cells to another worksheet
  132. Using a Variable in vba SQL to create a table
  133. "Autofilter " Unique Values and Copy To a New Sheet
  134. How to return hostname
  135. How to allow user paste(Ctrl + V) a row to protected sheet(some columns are locked)
  136. update excel cells automatically
  137. resize message box
  138. Change the CASE of data
  139. Macro for coding an action based on 3 columns of information
  140. shared workbooks
  141. automatic copying and moving data
  142. Loop Until
  143. Always Reference Last Column In Table
  144. User Defined Function - Where to type in?
  145. Disable the task pane shortcut
  146. My Code takes too long to execute
  147. Need help giving presentation to some raw data
  148. need help converting format
  149. method to keep workbook from being moved
  150. Macro creating new worksheet. Is it possible to write running code for sheet
  151. Autofilter cell reference formula
  152. How do I get VBA to copy the MajorGridlines.Border.LineStyle into a variable
  153. Can I Make My Macro Faster?
  154. Code I Have In A Module Slowing Down Data Entry
  155. Personal.xls Workbook
  156. Can't seem to get the automatic selection of data present down!
  157. spin button to scroll through combo box
  158. moving cursor on 2 worksheets
  159. Sub or function not defined
  160. create macro to copy paste many rows at once
  161. 2 bits of code - different result. why?
  162. Validate date entry in a text box.
  163. code to select all data on sheet
  164. find and highlight searched data
  165. Conditions inside my Loop not working
  166. run macro every 5 minutes
  167. Macro for color index
  168. Spin Button Event Change
  169. Diabled Save as
  170. Locating sections of time value using vba.
  171. Using variable to define a range/subrow of cells
  172. batch calculations from two worksheets
  173. Does Solver crash Excel 2003 ?
  174. Lost the copied data when run Worksheet_SelectionChange function
  175. sumif cell colour = white
  176. Error in userform when error in worksheet
  177. Problem overwrite protected file via VBA
  178. Referencing a range from a different Sheet problem
  179. Command Button Help
  180. Did User type "01/01/08" or "39448"?
  181. Loop macro to run on each of several sheets in a workbook...
  182. Variable for Cell Objects?
  183. Deleting all records in a access database table from Excel
  184. code required to copy and paste rows matching a criteria.
  185. Code for condictional great than
  186. windows 2003 server username
  187. working with multiple combo boxes
  188. use 'on time' from time specified in a cell
  189. Deleting Integers
  190. Autofill to LastRow but Miss Out Some Rows!?
  191. Check to see if Database has been created
  192. Need help on transpose
  193. Hiding or Making Buttons unavailable
  194. Transposing Column to Rows
  195. Entering Value in Blank Cell
  196. Cell Duplicating Userform Results
  197. Coppy an undefined number of cells from one sheet to another
  198. Activating the First Cell Containing Numeric Data in a Table
  199. Repetitive Changing
  200. Problem in Transposing
  201. Worksheet_Change event not working on xl2003
  202. Making cell values correspond with Drop down List values
  203. Removing macro references in a spreadsheet...
  204. Excel XP - Print Areas - Page breaks
  205. Edit Email Macro - Lotus Notes
  206. VBA Chart - Reading and Writing MajorGridlines
  207. lock cells from editing
  208. Looking for easier way to create my spread sheet.
  209. How to open additional workbooks WITHOUT taking focus?
  210. Repeat find and replace
  211. Running a macro from a if statement
  212. click on a date on the master worksheet and it take me to the appropriate worksheet
  213. Solver problem
  214. Check for duplicate then move data
  215. Column Sort Macro 1004 error....
  216. Filter a Column by Another Columns Value (Grouped)
  217. How to Update One Tab With Find & Replace VBA Code???
  218. Executing a Macro Across Multiple Worksheets
  219. Find & Replace Stop In Current Tab - Not Go To Next One
  220. Finding the first non-blank cell in a column
  221. User Form to Enter Information
  222. conditional formatting with one criteria but for two cells
  223. VBA if formula based on cell colour
  224. Macro that Creates a chart with selectable series ranges
  225. Break Tracker program using excel vba
  226. Hiding Excel
  227. Match column from sheet 2 to sheet 1 and copy rows if match exists.
  228. Multi-Currency
  229. Visual Basic and Macros buttons inactive...
  230. Find & Replace Dialog Box - Error Msg When Implementing
  231. Entering formulas using activecell.offset
  232. Range.Cells method
  233. Subroutine to split cells
  234. Emailing multiple files to multiple recipients
  235. Password Protection and default sheets
  236. Pause macro to enter value, continue macro
  237. lookup username in Citrix
  238. Arrays to Column Vectors
  239. Duplicate data when typing
  240. active column headers for sorting
  241. linking access table to excel
  242. If - else type mismatch
  243. TimeSheet: When an end time is after Midnight
  244. VB .NET Code Generation
  245. Looping and Solver
  246. Searching workbook for a named sheet
  247. Total Usage. Date Problem
  248. databasing macro
  249. The next for For loop?
  250. changing chart scale with VBA