PDA

View Full Version : Excel Help



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

  1. Attach ActiveSheet to Email
  2. Formatting a Cell
  3. Name definitions lost after import
  4. Forcing user to accept macro?
  5. Use worksheet functions in VBA w/out opening sheet
  6. Calling a Worksheet_SelectionChange Subroutine
  7. Adding Date to File name
  8. Solved: Need a replacement for sub underneath sub
  9. Solved: Data Validation Error
  10. help speed vba code
  11. Loop problem
  12. IF Statement
  13. Solved: VLOOKUP as a sum
  14. Help:How to identify the sheet number of the first sheet?
  15. Solved: Scroll Bar Length
  16. Excel 2007 and Conditional formatting
  17. Solved: Excel 2000 commandbar question
  18. VBA LogParser and Yahoo RSS feeds
  19. Issue about size in excel
  20. Solved: Position Values on Stack Bar chart
  21. what is wrong with this code?
  22. Array manipulation
  23. Solved: set reference to Windows Script Host Object Model ???
  24. Help with Index Custom Function
  25. Solved: Count Total Columns used in Sheet
  26. Inserting worksheets automatically in the same workbook..Guidance reqd
  27. Cutting a loop short...
  28. Code modification for updating
  29. Empty Cell Reference
  30. How to transfer the data from other Workbooks to my worksheets in this case
  31. Dynamic toolbar fails under certain condition
  32. Help:User interaction when code running
  33. Solved: excel 2007 saving to 97-2003 compatible
  34. Suggestions please.....
  35. code for review - Excel "new window" substitute
  36. Deleting identical rows between sheets?
  37. Solved: help: How to get cells data for calculation in the best way
  38. Wraptext
  39. How to set Iteration Times in Solver with macro
  40. Log-in server time
  41. Excel
  42. Cannot copy a range....
  43. SUMIF question
  44. Solved: month end reminder
  45. Completely remove form from Excel file
  46. Solved: Conditional format
  47. Solved: WEEK DAY REMINDER
  48. restore excel to default
  49. Make directory at Network Login name
  50. Solved: File Search in Excel - hidden files?
  51. Solved: Combo Box: set possible values 1 thru N in code
  52. COMBO BOX question
  53. Solved: Rename object and code
  54. Solved: Save data to notepad file and leave link in worksheet
  55. Incrementing the previous value
  56. Solved: Pop up data in Excel
  57. Find Local Time
  58. Vlookup help
  59. Solved: Printing multiple pages based on cell
  60. Calculation by VBA
  61. Solved: Opening a window to the active.path location
  62. Time Elapsed
  63. Solved: Show remaining time
  64. Solved: A "Browse" option for File Save?
  65. Solved: Define constant path
  66. Can't Populate Recordset due to SQL code
  67. Solved: Deleting a part from a parts list with a macro
  68. Solved: Upper, Proper, and Date Formats
  69. Solved: Using a String to Run a Macro
  70. Userform Treeview
  71. Solved: Getting Page Count for a Workbook
  72. Solved: compare worksheets
  73. Solved: Variable type question
  74. Solved: Conditional searching using VBA
  75. Searching Cells for String
  76. Solved: Excel Code Efficiency with DB Connection
  77. Solved: Download file from web
  78. Solved: A Simple(?) ComboBox Query
  79. Referencing Cells in changing worksheets
  80. VBA Find and replace in XML/Text file
  81. Solved: Casting to Text
  82. Solved: Copy to OPEN Workbook, not named...
  83. How to get the data from the "Staff Record.xls" in VBA
  84. Substitute variable into a range
  85. Football Cup maker
  86. Solved: ComboBox & Dynamic Arrays
  87. defining a data source as a variable
  88. Solved: Selecting a Cell on a worksheet.
  89. Solved: Import by tab name
  90. Column Sorting
  91. removing duplicates
  92. Solved: Hide column on selection change
  93. Using spinner in a protected sheet
  94. How to change sheet name at close excel workbook
  95. VBA Help in books
  96. Disabling the "Unsafe ActiveX controls" promt in excel
  97. Help:Just some clarification...
  98. print multiple sheets based on user choices
  99. Last Date Used:
  100. Solved: Help with array formula
  101. Row and Column Numbers in VBA
  102. Solved: Question on sheet names and Copy
  103. Find Method To Find 2nd Occurence
  104. Solved: word wrap or new line
  105. Prevent VBA generated charts from refreshing
  106. Hide rows based on cell in row
  107. Publish Selection to Web
  108. CellColor Macro Not Working
  109. Solved: "Tagging" a Cell
  110. Solved: Paste Special,Text question
  111. Auditing in Excel
  112. Newbie help: advanced table manipulation
  113. Seek help to highlight number.
  114. Solved: Looping required
  115. Calculations between Textbox values on Form
  116. Macro - Pivot Tables
  117. Union Query in VBA
  118. Solved: clear cells if, like reset
  119. Searching a range
  120. Show sheet based on serial number
  121. Need help setting tab orders
  122. Solved: Sloved:Why GetOpenFilename not working
  123. 180 Day Calendar
  124. Excel Lists
  125. Create Summary Sheet
  126. Hide Rows based if column I = 0, then set print area from row 80 to everything visibl
  127. Solved: Data Validation Code To Force Prior Cell Entry
  128. Row entry without keeping any row blank
  129. Solved: Copying Workbooks without disrupting the original
  130. Solved: Prompt to save on close (askes if already saved?)
  131. Creating charts automaticaly in Excel
  132. Solved: Excel 2007 ExportAsFixedFormat
  133. Version clash
  134. Solved: Message box Format??
  135. Solved: removing spaces
  136. Solved: Amend cell in row based on value in first cell
  137. Multi-Delete Function Problem in ListBox1
  138. delete rows based upon external list
  139. inporting external data
  140. VBA to EXE
  141. Solved: Remove Formula
  142. Transfer the data from the multiple files into 1 worksheets
  143. Solved: Hyperlink Address
  144. Extract Text
  145. Loop Comparison Theory Discussion: For.Nxt vs. For Each
  146. Diaplay text in a cell
  147. Making URLS Hyperlinks
  148. vlookup worksheet formula error: sub or function not defined?
  149. Solved: Conditional formatting
  150. I want to change the color of some letters, but it does't work
  151. Playing w/ Arrays
  152. Counting Multiple Criteria
  153. Problem of open all file(s) in the listbox
  154. Print Setup via VBA
  155. Solved: delete columns with an array collection
  156. Problem in the Range Row index
  157. Solved: IsError Function
  158. VBA obfuscate data & find cell
  159. Solved: Populate Column based on contents of range
  160. Solved: Help with Lookup Function
  161. Adding sheets to summary
  162. Automatic close and save
  163. Dummy post so I can creat4e an attachement
  164. Sort data and past into new sheet
  165. Problem using arbitrary column length in a user defined function
  166. Solved: populate combobox problem
  167. Dynamic Plotting
  168. Solved: Linking Again?
  169. How to Give Upper & Lower Limits to a Plot?
  170. Solved: Delete duplicated rows
  171. Solved: Migrating frm Excel 2003 to 2007
  172. Solved: Nomenclature for referencing named cells in .Formula Code
  173. Solved: Prohibit or restrict copy
  174. Solved: Populate UserForm TextBox based on Worksheet Lookup
  175. Problems in calculation of Means, Max, Min in VBA
  176. Solved: Extract number of digits/characters of a variable
  177. Sorting producing wrong result
  178. Solved: Is there a way to have code trigger an event when trying to save or print?
  179. Macro on Window Activation
  180. ASCii code to allow a space
  181. Opening an Access Form via Excel
  182. Solved: Search for Missing Module/Code?
  183. For-Next Loop Help
  184. Disabling worning message while closing a workbook.
  185. Solved: Tool to check VBA code
  186. Solved: Cannot Open The Excel File
  187. Solved: How to copy data from one sheet to another
  188. Solved: Activate sheet after add/sort sheet executed
  189. Solved: Change event in range selection
  190. Solved: More than 1 Validation in Single cell
  191. Delete duplicated rows 2
  192. Solved: Two instances of the same form?
  193. Solved: explain formula
  194. Compare 4 worksheets in a workbook
  195. Solved: Difference between UDF & sub routine
  196. Solved: Help w/ Summing Range
  197. Solved: Onchange event to check a date
  198. Possible 1-liner
  199. Solved: Working with visible rows
  200. How to identify non-whole number?
  201. Find all instances of a word and return the results in a userfrom - not working
  202. Solved: Open a workbook & copy data using
  203. Solved: truncate and add two text boxes into third
  204. prevent minimize window
  205. Target Line on Plots
  206. Changes formula to value- wrong number format
  207. including string in string
  208. If your search string isn't found...
  209. Copying from a Dynamic Source!
  210. Don't show the opening/closing workbooks
  211. Instring Replace: Error
  212. Solved: Copy Paste using macro involving 6 different workbooks
  213. Solved: Workbook_SheetSelectionChange Event
  214. Solved: Highlight Duplicates
  215. Goto nested if's
  216. Help: How to change color pallet?
  217. Cell formula question
  218. Change properties of a Combobox
  219. Monitor the Caps Lock Key
  220. Solved: two routines under one event, but they don't work?
  221. Drag & Drop TreeView
  222. Calling multiple sub procedures fails after 1st Sub!
  223. Solved: Calendar value to form
  224. Solved: Loop through controls on userform
  225. Solved: Delete Rows-However keep the first found Row
  226. Watch Window to jump to cell?
  227. Question for the file(s) in the listbox
  228. Page subtotal macro combine
  229. Appel = 10 in Excel spread sheet?
  230. How to creat Dynamic Text box in term of size
  231. InputBox Auto-Complete Function
  232. VBA module's name.
  233. Populate URL address using VBA
  234. Solved: Prevent User from moving userform
  235. Solved: Filtering Values and splitting worksheet according to the values
  236. Distinguish the xlup and xldown
  237. Putting A Date Into A Cell
  238. Data Validation
  239. Solved: use formula in VBA for vlookup
  240. Solved: Textbox always displays end instead of start
  241. Fixing Numbers
  242. Which method: Vlookup, InStr, Other?
  243. data and dates
  244. check cells content before executes macro
  245. Watches Window: View what row active?
  246. Call Stack overflow
  247. Solved: Consolidation macro
  248. Solved: Last Used Cell
  249. Excel sending data to Several E-mails
  250. Solved: Msg Box to appear once on opening a WB