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. Macro help?? highlight partial rows?
  2. Time Stamping
  3. Is there a way to make a button appear once a macro is run?
  4. Do not Print specific cells
  5. Returning value > 32767
  6. Renaming Spreadsheet causes macros to fail
  7. Looping macro
  8. Calculation macro upon opening and closing
  9. Transferring specific rows from fast filtered worksheet to another worksheet
  10. SaveAs in Auto_Open with date and title
  11. Area chart returns -1 for pointindex?
  12. Excel Add In question
  13. find and match
  14. extract number with dot from text
  15. Replace the name of "Named Ranges"
  16. macro that hides data fields in pivottable not working
  17. Not able to use DataObject
  18. Select multiple charts to be copied
  19. HTML Format Within a Cell?
  20. macro VB
  21. defining Column Reference with ADO connections using VBA
  22. How Do I Have Defined List in AutoFilter Pulldown and conduct a Contains Function
  23. Msgbox that counts down from 5 - and closes automatically
  24. Current Userform TextBox
  25. Select Case Which_Macro_Called_Me
  26. Macro to address cells in the next column to selection
  27. highlighting text in a textbox
  28. Error 1004 when listing references
  29. create/assign Outlook tasks from a range of cells
  30. Looping problem
  31. Variable Last Entry
  32. Adding $ Values for multiple categories to specific employees
  33. Privot table and Privot chart...help
  34. Hide macros from Alt-F11 but show macros on Alt-F8
  35. Please help with a calculation
  36. copy paste and print
  37. email one sheet to many recipients based on email list
  38. Copy the active sheet
  39. PivotTable modifications via VBA
  40. RSA Code Problem
  41. Issues with macro name when file name changes
  42. Format/AutoHide rows
  43. VBA help for a simple macro
  44. Set Print Area based on Sort
  45. Message Box Popup with Yes or No
  46. combobox accepting text input
  47. counting used lines
  48. complex macro
  49. Excel VBA help
  50. To erase certain texts
  51. How create full spectrum 9 by 5 and 10 by 5 matrix?
  52. Finding Multiple matches in same column
  53. Combobox- Control Toolbox
  54. Copy data to another workbook
  55. Running Macros from my Add-in
  56. Extreme Excel
  57. How do I make a data range globally available?
  58. Delete column IF code
  59. Creating a CSV document from an Excel Sheet
  60. 'For..Next' & 'If Statement' Code
  61. Merging previous one column (after insertion of a row) in a range
  62. Image Positioning
  63. Copy a sheet without going to that sheet
  64. How to create prvot table and privot chart using Function which
  65. How to count the number of cells
  66. Send email when deadline date is approaching
  67. ToolBars and Add-ins
  68. Automatically zip and email when saved
  69. excel vlookup automation using vba
  70. Consolidate data
  71. Looking for a code
  72. Macro to change dates in a selection
  73. Macro to insert row and paste from another
  74. copy cells that contain..
  75. Excel crashes every time I try to format
  76. Trap PivotTable down arrow click event
  77. SetFocus not working
  78. using VBA to hide columns and rows that do not have cells with a specific format
  79. How can I randomly reorder my values in my array?
  80. You have modified a sign project.
  81. run 1 macro automatically after any value chosen from drop down
  82. Multiple New Workbooks based off Sheet Data?
  83. Automatic analysis in excel
  84. interface to make it easier to fill out database
  85. scrolling buttons
  86. Test cell value between values
  87. Can I set a range variable in Public section?
  88. How to reverse XLA conversion?
  89. Macro and select multiple values from Dropdown
  90. Macro Security Level
  91. E-mail An Address In A Cell
  92. set cell format to text
  93. Macro Loop and Paste in next empty row
  94. Can I graph an auto updating cell
  95. macro that highlights all cells that end in "000"
  96. Assistance with Split Function
  97. Standardizing Postcodes
  98. find and input data
  99. macro to automatically export gif/png of carts
  100. Autofilter for Bold text
  101. Macro to break up a string into different cells
  102. Code for VeryHidden Sheets
  103. selecting the last cell of text
  104. First Sheet Become Menu
  105. Chart displayed is selected via a dropdown menu
  106. Converting date/time into minutes
  107. How do I make a Clear button?
  108. Unprotect a workbook with VBA (BUT) re-protect it when saved ???
  109. Advanced Timesheet
  110. Writing a macro that pulls data from a specific worksheet
  111. Changing Value
  112. TextBox Formatting on a Form
  113. Delete Row Based on Worksheet Name
  114. 2 if statements in Script?
  115. Truncating Long Data String
  116. Excel dropdown lists
  117. If then problem
  118. macro code to show userform
  119. Loop, Copy and Transpose
  120. don't replace VBA code
  121. Script Running on Hidden Workbooks
  122. Type mismatch problem
  123. how to pass parameter to different sub?
  124. Various macro issues linked to DDE
  125. UserForms assistance Required
  126. Updating a list with a macro
  127. Generating formulas in Excel from VBA macro
  128. remove duplicate rows
  129. non-active function until push on button
  130. How to capture value from Check Boxes
  131. Save As Text File
  132. changing Tab Colour & Name to match
  133. Counting Data
  134. open a workbook with changing "Drive Letter"
  135. Question about Add-ins
  136. Code to search for the next cell with zero
  137. AutoFilter then populate combo
  138. PasteSpecial not working perfectly
  139. Problems with Copy/Paste Code
  140. Create a list in another sheet based on few conditions
  141. Macros in custom menu not working properly
  142. Compile Error on custom function
  143. macro for deleting duplicate rows...
  144. sorting by column
  145. Copying and Pasting through Worksheets with Macros
  146. ComboBox Truncating Values
  147. InputBox and ranges from another worksheet
  148. Writing Descriptions for functions
  149. Printing noncontiguous ranges on 1 Page
  150. Simple Question
  151. Concatenate Date and Time
  152. InputBox
  153. automated row erasing in excel
  154. Export file from Excel
  155. Help With Function
  156. Using a cell value as criteria in a data import script
  157. Calling Sub in Personal.xls from other sub in VBA
  158. Macro for autofilling formula
  159. How to query a worksheet of data
  160. Selecting cells using "offset"
  161. Insert images into a comment
  162. Concatenate cells while keeping formatting
  163. Column Issue with Range
  164. Could really use some help...
  165. VLOOKUP Closest Match Not Close Enough
  166. Use find to compare sheets
  167. populating your listboxes with code in 'declarations'
  168. extracting file contents from different folders!
  169. Generic Format to Call any .exe
  170. FOR NEXT question
  171. invalid next control variable reference
  172. Extract File From Outlook Message Saved In Windows Folder
  173. Loop & Find problems
  174. Delete Rows based on cell value and then Insert rows alternatively with a formula
  175. Create text from multiple cells/ranges
  176. Copying Tool Bar
  177. Macro for creating named ranges from relative referencing
  178. looking to filter a special number
  179. Sort Column, Delete Rows, Delete Column, Move Molumn, more inside?
  180. Hyperlink
  181. Tracking OT, trying to make it user friendly..
  182. Excel VBA code to look at 2 Columns F & G which contain Numbers right upto the last r
  183. Increase Number Invoice
  184. Pivot Table Error
  185. Select a range using "Offset"?
  186. Macro - Can I try two different passwords without debug?
  187. Escape My Debugger!
  188. Custom Tool Bar in 2007
  189. excel macro request
  190. Hyperlink to launch an app and a flie
  191. Macro to Copy value in a given destination cell
  192. Open Workbook Event
  193. File naming?
  194. Matching Criteria Between Sheets?
  195. Charting and VBA
  196. string processing
  197. Return to previous Page
  198. Track changes in Excel??
  199. Automatically select in MultiPage
  200. SpellNumber for Three Decimal Place Percentages?
  201. Time delayed macro
  202. userform run error
  203. Turning a date into a mmm-yy string
  204. VBA - button to move to another sheet to same cell
  205. Copying Userform?
  206. Create Function fro adding Cricket Overs
  207. Selecting range with VBA - should be easy
  208. Values on Excel Userform
  209. Copy sheet to all workbooks in a directory AND..
  210. Auto populating a summary table
  211. VBA script for collation of data
  212. Restricted area
  213. Creating new sheets with Data
  214. Returning the time from the timer
  215. Quotation mark?
  216. Problem with my code
  217. Macro to create new Workbooks
  218. Amend code to Sort Sheets by number
  219. Formula for color coding
  220. How do I get a UserForm to populate the next empty row in a worksheet?
  221. calling a class by name
  222. Problem with if statement
  223. position cursor on command button when userform opened
  224. Column name problem
  225. Delete Filtered Rows - Leave Headings
  226. How do you go back to the previous workbook
  227. Readonly Macro Problem
  228. Regressions and associated error messages
  229. Making a test
  230. Return to active sheet-cell content copy
  231. Exporting Word Chart to Excel (Resizing Chart)
  232. Highlighting and printing
  233. How to create a distribution plot
  234. File Open macro
  235. Auto date stamp
  236. Renaming a column?
  237. Change Behavior Of A Built-In Toolbar Button
  238. Trouble renaming button from Forms
  239. Deleting Rows
  240. Edit code to copy whole sheet
  241. clear filter for active coulmn
  242. userform appearance
  243. Cricket Function Overs converted to Bowls
  244. Macro for collecting data from one sheet and moving to another ?
  245. Assign VBA code to button on .copy sheet
  246. Error Naming Tabs
  247. findsearch in workbooks using userform
  248. Event handler or a macro
  249. loops - automate the copy and pasting of each individual cell in this column
  250. Excel formula to duplicate from one sheet to another