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 162 163 164 165 166 167

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