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. add a row and insert a name alphabetically in a range
  2. macro inside command button and combobox
  3. Deleting rows based on criteria in reference worksheet
  4. Exporting a selection to a text file using a filename specified in a cell?
  5. VBA Code to Add Event to New Worksheet
  6. connecting different sheets
  7. Fill cells in a column to the end of a table
  8. Copy Cells from various workbooks to central workbook
  9. Worksheet event
  10. Default value/text for variable in Function declaration
  11. Hyperlink
  12. Userform putting info into designated cell
  13. Macro to "Drag" rows if blank based on customer name
  14. Data Duplicating in Macro
  15. Line Nos. in Visual Basic Editor
  16. delete duplicate rows - looking at specific cells
  17. Merg cells with the same value
  18. Finding the last letter in a cell
  19. problem with relative range name in VBA
  20. Cell value test
  21. not allow a save action if ANY data is missing
  22. Batch Macro
  23. Code to search within sheets
  24. AutoFilter coding
  25. VBA range cells
  26. Command Button Caption Wrap
  27. auto scroll of worksheet
  28. Countif/Frequency
  29. Time step or waiting time
  30. The macro works - but why?
  31. Cell not working with 2 tasks
  32. Data worksheet transfer problem
  33. mailto
  34. QueryTables command for all queries in an excel sheet
  35. Creating two different charts based on a single pivot table based on condition
  36. Infinate numbers of data
  37. how excel web query(*.iqy) handle the login page
  38. Update cell every half hour
  39. vlookup maybe
  40. describing VBA commands/code
  41. Transfer Data to different worksheet
  42. Inserting a Row that maintains formula from the row above or below
  43. formula for unit price with minimum amount
  44. Create selection of worksheets
  45. Automated email
  46. Retrieving information from a web form?
  47. Script Language.......
  48. Copy & send single sheet with values and no formulas
  49. convert sign within macro
  50. VBA conditional formatting not working
  51. Create a mail using the mailto: function
  52. combobox matching
  53. Copy data from one large worksheet to multiple workbooks
  54. Converting Office 2003 VBA to 2007
  55. Multicolumn Combobox
  56. VBA Conditional Formatting by first three letters in range
  57. Keeping the column and increment the rows
  58. Importing an exporting data
  59. Copying from IE embedded worksheet
  60. Pasting multiple ranges which offset.
  61. Conditional Format of Specific Cell in Variable Length Column
  62. Can you edit data/form in Excel menu
  63. Opening Workbook using only first few letters
  64. What is the alternative for the Property UsedRange
  65. Find Next ???
  66. UserForm
  67. Excel Problem Using Case and worksheet change
  68. Color Palette on Userform
  69. Using Named range to populate a Combobox in userform
  70. Win32 exception while closing from VBA
  71. ComboBox option
  72. Color cells
  73. Copy and referencing problem !
  74. Referencing data problem
  75. Input Sheet2 Output Sheet1
  76. Extract Conditional Formatting Data
  77. How to Unhide Database View
  78. Import Addresses From txt file
  79. worksheets.range?
  80. UserForm Code
  81. VBA to put amounts in columns based on Code in column C.
  82. disable VBA screen
  83. excel cost calculation enquiry
  84. Adding a .hlp file
  85. auto scroll of worksheet
  86. Email macro
  87. Selecting a range variable
  88. Inserting a row but maintaining formula integrity
  89. Code to Add Cells to Active Cell
  90. Deleting a row based on date
  91. Calculate workbook
  92. Spin button link to another cell
  93. Exporting cell value
  94. SmartTags
  95. Copy data without activating worksheet
  96. userform question
  97. select only north or south data and link it
  98. Deleting last row in the list table
  99. code to save selected(pre defined)text to text file
  100. replace a range of values in a column
  101. userform combobox
  102. Explain code - contents of the active cell
  103. how2 export a VERY long string out of Excel
  104. Reference LastCol VB
  105. week --> Month
  106. checkbox not responding
  107. checkbox / radiobutton
  108. Pulling data from SQL to Excel
  109. Create copy of multiple worksheets and automatically fill in data from a main sheet
  110. VBA - Date Lookup
  111. Transponse Pivot Table Data
  112. VBA Hangs after ClearContents
  113. Edit code to add extra criteria
  114. Delete rows macro error
  115. Footer with multiple rows
  116. Remove custom formats
  117. Excel formatting
  118. Delete last row from the list (converted from range)
  119. End(xlUp) code in VBA
  120. How create first document, excel VBA????
  121. explain the FuzzyLookup function
  122. populate a listbox with dates
  123. Importing information from one cell into multiple cells
  124. Change Print Area to Disregard Blank Cells
  125. vb auto data sort when entry 2 cell
  126. calculate the third angle of a triangle
  127. Number combinations to equal total
  128. macro to create a macro?
  129. listbox
  130. Deleting worksheets, printing to Adobe, and moving to a new workbook
  131. Transposing Dynamic Ranges of Data
  132. Loop, Copy and Transpose
  133. Macro Question: Multiple Worksheets
  134. nested Loop
  135. Entering a new column without affecting the VBA
  136. Can Images Have Formulas?
  137. Macro to update
  138. extracting specific cell values
  139. Formatting Excel
  140. Sequential PO#
  141. save multiple worksheets and name workbook
  142. Selecting Specific Cells
  143. Selecting only certain sheets
  144. Printing in a macro
  145. Counting in a macro
  146. How to use the count function in a macro
  147. Summing Range
  148. file types
  149. Email Options from Email
  150. Converting selective formulas to text
  151. Defining a button to increase a cell value by 1
  152. How to subtitute object name for variable
  153. Auto incrementing value in cell
  154. Delete Newest (by date) Duplicates
  155. Copy from multiple worksheets into one worksheet
  156. Read Only Prompt
  157. No password asked when using VBA to protect Sheet
  158. Reducing size of worksheet after using macro
  159. Forecast? Trend? Average?
  160. move cells based on partial-content.
  161. print select and show msg.
  162. Assigning Marco to cell which brings MsgBox
  163. counting formula
  164. Alternate row shading on Pivot table results?
  165. problem copying sheets in excel 2007
  166. Counting Strings
  167. Copy cells from one workbook to another's next open row
  168. Auto copy data from one workbook into another.
  169. Classes
  170. Mail Merge entirely in Excel
  171. Workbook linking
  172. Macro copying from WB to WB
  173. Appending data into an Access db from Excel
  174. Progammatically Add/Modify the Validation
  175. Extract and Exchange within a String?
  176. Defining a range
  177. Pivot Table calculation with constants
  178. VBA code to render a userform unusable after a certain date
  179. Adjust Text Box Width on Userform
  180. automatically find end of data using a macro
  181. Pop-up message box macro after conditional formatting?
  182. Cell range protect/unprotect toggle
  183. Removing password in a macro
  184. shortcut to copy to main excel file
  185. Shortcut - macro
  186. Copy data from 1 sheet to other sheets automatically
  187. Move Excel files to an Outlook folder
  188. Mid statement object reference error.
  189. For next loop question
  190. MODI ocr
  191. Return to origination
  192. Routine to create navigation buttons
  193. delete all occurences of a value on a worksheet
  194. Copy paste from one worbook to another workbook
  195. macro - inserting rows based on ID
  196. Sum & Compare
  197. Application/object defined error when changing the value in a cell
  198. Excel insert a row automatically
  199. Auto filtering in drop down
  200. running a sub in another workbook
  201. Deleting last row in the list table
  202. Macro to add formula
  203. Obtaining an offset value from a userform combobox
  204. Banner with excel
  205. Shift down to next cell in column
  206. Insert delimited string
  207. Listbox Data Transfer & Formatting
  208. Colour to Value
  209. Calculating Averages
  210. Calculate % when total cell not static
  211. Extract a Value
  212. UserForm
  213. Pulling data from multiple tabs
  214. Marco to Cut/Paste row
  215. Switching between workbooks in a macro
  216. Macro runs twice unexplainedly.....
  217. Column Data
  218. how to write a macro that will select top 3 f
  219. Return characters based on another column
  220. Need an Api to use from vba
  221. Increase Count in Cell
  222. Tale of 2 workbooks
  223. Maco that will remove certain characters
  224. Excel 4.0 Macro
  225. The "Custom" Box in Excel 2007
  226. Start/Stop Time counter
  227. Create Counting Calendar
  228. Phantom Excel.EXE Process
  229. automation spreadsheet
  230. Conditional Formatting problem
  231. Showing Userform
  232. set values from > or <
  233. Comparing Ranges
  234. After formatting PC and reinstall Office macro no longer works.
  235. Macro to delete VBA
  236. MISSING: Microsoft Windows Common Controls-2 6.0
  237. Populate Record in listview
  238. Changing cells color without clicking command button
  239. Course Bookings Run-time error '9': Script out of range
  240. Macro to create new sheet
  241. Calling UDF
  242. Populate cells using multiple criteria
  243. Macro Code to fill a variable number of rows
  244. Cannot delete macro on a shared drive?
  245. Conditional process based upon formula results
  246. Searching Hidden rows
  247. Opening variable filenames
  248. lookup for values in another workbook,2 criterias and summarize
  249. Assign values to ratio buttons
  250. Application.OnKey replaces space