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. Vlookup Problem!!
  2. Data merge from Excel to PowerPoint
  3. How to tell if a workbook is open
  4. Deleting Duplicate Entries
  5. Network Printers
  6. Subtotals Problem with Hidden Sheets.
  7. Printing multiple records with 1 template.
  8. speed of program issue
  9. Send Keys On Internet Explorer
  10. Vlookup, returning multiple values
  11. Open Word, Copy and Paste Data to Excel?
  12. Side Menu
  13. Workbook_Open Event
  14. Update Links Macro
  15. multiply entry from coloum F with certain amount, and output into field XX
  16. VBA code summarizing sheets.
  17. autofilter and protect
  18. Cut Text from a certain point
  19. Time Stamp web query
  20. export or import many querys from access to excel
  21. Import & Export Values
  22. How can I find / replace a * in Excel?
  23. Filter or sort multiple values in a cell
  24. Slow running macro
  25. Autofilter based on date and condtion
  26. If cell in column B is blank, delete entire row
  27. select last cell in a row (up to column K)
  28. Select 2 ranges at once
  29. Multiple IF THEN ELSE statements not working
  30. combine on every 6 same data
  31. Create Outlook Appointments from Range
  32. Excel loop to delete row on condition..
  33. opening another workbook?
  34. Keeping track of used vacation hours
  35. Unload form bug
  36. Opening a Workbook At a Specific Time
  37. Incorporating Lookup Value In Macro
  38. Clearing cells on another sheet
  39. Staffing Board Part 2
  40. macro to delete one character in a cell
  41. CSV File location in Pivot Table
  42. Array Macro Question
  43. Sum Macro
  44. conditional row delete and autofilter
  45. Addin path not updating
  46. Saving in wrong location
  47. GotFocus LostFocus
  48. AskAndDo timer
  49. Changing the caption of a Command Button
  50. Macro to insert and copy lines by quantity
  51. Creating A Cell with Running Time
  52. Data validation - Whole Numbers
  53. Format date to "MMM" format
  54. auto emails by cell value
  55. ActiveWorkbook Inheritance
  56. Insert formulas in cells
  57. List of dates and events - returning only the last date for a particular event
  58. Filling a range of column with a certain value
  59. Finding Last Row
  60. sorting from table to sheets
  61. Code should runs once per line
  62. Problem with ProtectSheet
  63. Making choice either 1 or 0
  64. Deleting and inserting rows
  65. date shown wrong via input box
  66. VBA code generating from macro
  67. Count or if statement re dollar value in cell??
  68. Auto-populate custom form
  69. Getting out names from codes
  70. save name and get row number question
  71. vlookup or find on my sheet
  72. sheet referencing
  73. Pivot Table conditional Format
  74. how to use ranges
  75. Changing empty cells to 0's
  76. Copying from Websource and Pasting on Sheet
  77. Add Entry... ?
  78. send data
  79. COUNTIF question
  80. Condensing Repetitive Code Distributed to Multiple Sheets
  81. How to clear the Pivot Table in VBA?
  82. Finding Roots of a Polynomial
  83. Refreshing External Web Data Exactly on Minute
  84. Copy selected data from one column to another
  85. Currency Conversions with If Statements?
  86. Colour of List Items
  87. Referencing filename in a saveas function
  88. Screen Updating with Userforms
  89. Protecting VBA code
  90. Microsoft excel has encountered a problem
  91. Problem setting pivot table page filter
  92. Copy data from a different workbook
  93. Select Radio Buttons on Websites
  94. Problem with ISBLANK function
  95. Put id then put image file
  96. find something in Column A, and find whats next to it in Column B
  97. code for creating form for logging phone call details
  98. unsort after sort
  99. Run Macros from Multiple Drop down lists in same sheet
  100. Mail Merge Error
  101. asigning variables based on cell content
  102. Financial Calculator Functions
  103. ByVal Button As Integer, ByVal Shift As Integer
  104. Paste VALUES...not FORMULAS
  105. VBA code required for automated escalations in excel
  106. Calculate pallet configuration from many different products
  107. Excel VBA Free Lock from DAO Edit Mode
  108. 800x600 change to 1074x768
  109. Which Programming Language?
  110. Conditional formatting
  111. Printing selected items as a form - editing the macro
  112. Row Insertion Upon Data Update
  113. Problem with dateformat when copied from userform
  114. Auto Convert Values to Negative?...
  115. loop through the rows and then update the textboxes and captions
  116. Correct data with VBA
  117. Replacing "0" values with null string in array while preserving cell formula
  118. filling forms
  119. Set Combo Box Automaticly Show Time
  120. Validating a cell based on entries from other cells
  121. Selecting Columns using column numbers
  122. Use variable instead of hard cell reference
  123. Help Writing Formula
  124. loop to stop and wait for cell value change.
  125. auto consecutive numbering
  126. Excel Macro not executing from Oracle Forms
  127. Capital letters
  128. Count columns
  129. Excel 2007 won't lock cell.
  130. Pulling data from a charging file!
  131. Modify macro statement
  132. Text length in cell cut after 30 and paste in next cell to right
  133. programming custom search in excel
  134. Directions to setup a reference table
  135. Retaining Focus
  136. offset to next visible cell?
  137. Comparing Text Cells
  138. Run a macro when 'Enter' is pressed?
  139. Code doesn't update from a cell?
  140. SQL to return Data Types
  141. Password in Excel
  142. Use Last Value in Row entered
  143. Set Focus to excel application created by Create Object
  144. For Loop - How to exclude a sheet eveytime this code is ran
  145. Automating Formating Columns using VBA
  146. Trying to make millions :)
  147. Opening Access from Excel
  148. Merging the correct number of cell rows to fit a string of wrapped text
  149. TextToColumns
  150. Retrieving chart series name
  151. Using Excel to Complete Form in Internet Explorer
  152. Inserting formulas into a column of rows
  153. Conditional formatting maybe
  154. macro for deleting rows with repeated text.
  155. Using Worksheet_SelectionChange() event macro
  156. Counting Cells by font color problem
  157. Bank rec v2, deleting matching check #'s
  158. Forms in a Shared Workbook
  159. Calling a Variable Subroutine
  160. How to find last row
  161. Conditional Formatting - IF Statement
  162. Export to .csv
  163. Tab not working
  164. Printing multiple sheets
  165. Macro that makes a tab become hidden if they move to a different sheet or tab
  166. Remove part of string
  167. Insert Username who make last saved
  168. Conditionally Format Row based on Multiple Cells in Row
  169. Want to rename files in Excel using a list
  170. Converting General format in to HH:MM format
  171. Sorting usedsheet with macro
  172. Copying worksheets...
  173. Cells.Find when there is nothing to find
  174. Delete entire row when cell says delete
  175. Linking Cells
  176. Converting Time to Duration
  177. Solver and Worksheet events
  178. VBA Format issue - How to get the date to display as in 'mm/dd/yyyy'
  179. MACRO - combing workbooks
  180. Subscript out of range
  181. Testing for a #VALUE!
  182. Generating a refrence number for each new Entry
  183. Don't understand error with Range()
  184. Find Active worksheet after Workbooks.Opentext???
  185. Graphs Macro / If Statement?
  186. Pausing code on Error then resuming once resolved
  187. able to send data to text boxes in IE
  188. Deleting rows
  189. How do I select a range that will be changed later?
  190. Calling function from worksheet with nonconcurrent range
  191. Modifying the Shortcut Menu
  192. Null read in some cases when reading from xls using ODBC
  193. Resolved >>> Auto-populate cells with data from other cells
  194. scroll along row looking for values?
  195. Sorting Numbers
  196. key-based search
  197. Lookup execution time
  198. Module vs. UserForm - where should I be storing my code?
  199. Looping and copy/paste specific rows
  200. Making g a Popup window that shows results of a search
  201. txtbox Data Validation
  202. Call function with a variable name ?
  203. Lookup with (3) criteria
  204. Create Macro To Copy Moving Range of Rows
  205. Running macros/events clears undo history and clipboard
  206. UserForms, how to maintain cell formatting
  207. VBA code that will save all sheets in workbook to seperate workbooks
  208. UserForm TextBox Sum calculation
  209. Why does it work only with a breakpoint?
  210. How do I print 0.00 if the excel cell is empty
  211. A couple of questions
  212. Adjust chart size
  213. how to expand 1-5 to 1,2,3,4,5 ?
  214. save with condition
  215. copying files between folders
  216. Loop through worksheets not happening
  217. row#s of certain data in a table - Sort Data - How to update table w/new row#s?
  218. Automatically generate a list
  219. Tracing a Circular Reference in Custom Formula
  220. Bank Rec Project:deleting void checks
  221. Find, Copy, Paste from One Sheet to Next
  222. How to stop a loop at a blank cell
  223. VBA PasteSpecial problem
  224. Using macro to print
  225. Disable user input on TextBox?
  226. Move rows to different worksheet that meet certain criteria
  227. Use of If
  228. Filling down a collumn using VBA
  229. Removal of rows meeting certain criteria
  230. .Find ~ unqualified reference
  231. Count by Colour (Text) with other criteria
  232. checking for attachment
  233. VB Puzzle - any advice?
  234. Apply macro to all sheets!!!
  235. MSFlexgrid
  236. Formatting
  237. unprotect and protect macro
  238. Do Until question
  239. Copy and Rename sheet
  240. preventing excel to print bak to back
  241. Wrapping code
  242. CreateObject popup box
  243. Find Repeated Value in Column
  244. Macro with user defined inputs
  245. Copy a Textbox value from a userform?
  246. Visual Basic Language Support
  247. select special range
  248. runtime error 6: overflow?
  249. formula autofilled question
  250. Data Validation