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

  1. automatic run module
  2. Solved: Delete Certain Columns
  3. Autofilter Field
  4. Code help: dialogue box to add a toolbar
  5. Solved: highlight same model
  6. how to close an excel file from command line?
  7. Scroll Bar/Control Toolbox/Forms
  8. making calculation easier through data organization
  9. Solved: Manipulating Activesheet Shapes?
  10. Solved: Renaming Worksheet during Copy fails
  11. Delete row based on Data in two Columns
  12. Inputbox format
  13. How to exit loop
  14. Solved: function help
  15. Solved: add data in one cell based on condition
  16. misbehaving DirectPrecedents
  17. Solved: Loop problem
  18. Auto Save
  19. Need data from another ss
  20. Multiple User sheet protection and access
  21. dynamic reminder
  22. Solved: Solver querstion
  23. Challenging project - Date
  24. Solved: Open a Web Page on Validation
  25. help: Nested function as simple as UDF, but faster in calculation speed
  26. Solved: Create duplicate workbooks based on list
  27. input same value in multiple cells
  28. Solved: Multiple Tab Data to Chart
  29. xlVeryHidden in WorkBook_Open
  30. Disable link prompt from showing
  31. Keyboard
  32. Copying active worksheet to new workbook with module to go
  33. Solved: powerpoint paste
  34. Date Update
  35. Solved: "save as" subroutine and checking for saved status
  36. Solved: Find all instances of and then count
  37. Open minimized & save report (Newbie!)
  38. Pull data from web
  39. turn formula to value
  40. Export data to new WB and Add sheets
  41. Connection String in Excel VBA
  42. Keystrokes from Office Macro into third party App (SolidEdge 2D free)
  43. Solved: How to keep number value displaying fractional value
  44. Change Focus to non-office window.
  45. Solved: Copy Range and paste it into a insert comment
  46. Looping Through an Array
  47. Relational Lookup
  48. automatically delet pictures
  49. Solved: Duplicates
  50. Solved: hide columns based on value
  51. Solved: Delete row range based on criteria in multiple columns
  52. Excel 2007- Who is Using and Is it worth upgrading?
  53. Solved: Copy entire sheet to a new workbook
  54. Date & time problem
  55. Solved: creating a summary report based on column data
  56. Removing a cell from a selected range
  57. extract text in strings
  58. Solved: Empty Cell Highlight
  59. Solved: Dos Command in excel: "COPY " & file1 & " " & file2
  60. Add sheets and copy data
  61. how to create file open dialogue box for consolidation
  62. Need help transfering data into another workbook
  63. Sending E-mail from Excel via Comman Button
  64. Test if column has only one value?
  65. Solved: Deleting Columns on Conditions Matched with an Array
  66. Find & Rename Text
  67. Working two worksheets into a third worksheet
  68. Problems with winhttp
  69. Solved: Deleting rows with odd conditions
  70. Solved: Summing Problem
  71. Breaking up a cell
  72. Excel locking up when trying to delete all cell contents or select columns
  73. What IS the purpose of "Design View"?
  74. Capturing a list of files (for email attachments)
  75. Solved: Change Powerpoint Textboxes
  76. Solved: Mapping Excel Links
  77. Set the default file path and Extract the last value in nth occurence
  78. Solved: Compatibility
  79. apply this VBA code to work in two worksheets in one workbook
  80. Need help combining two sets of code into one sheet
  81. Solved: Another Array Question
  82. Use FIND, skipping one
  83. Calculation keeps getting changed
  84. Solved: Solver in 2007
  85. Read Only to Read/Write and back again
  86. Creating a List Array for use in an ADO query
  87. Setting up an array
  88. Hide Row if cell has specified word
  89. How have spreadsheets changed your work?
  90. Need VBA urgently......
  91. Solved: check for add in progmatically
  92. Compare same number in sheet1 and sheet2
  93. Find the "False" words in the worksheet
  94. Countdown timer in VBA
  95. Solved: Match & Fill
  96. Excel 2007 auto install add in
  97. Solved: Remove Custom Menus
  98. Solved: solver.xla excel 2003 help
  99. Solved: Code fails to run on Non-ActiveSheet
  100. Solved: Pop up box when clicking a cell
  101. Remove duplicates from Multiple columns than tally results
  102. Importing Web Page with Hyperlinks into Excel
  103. How to stop a running macro by user click event?
  104. Help:Left Function Library
  105. REMOVE ROW SUBJECT TO STRING VALUE -please review code
  106. Help to get last cell of selection
  107. Solved: Logic Puzzle hints
  108. Call a form in a other workbook
  109. simple loop
  110. On Error GoTo Again: Erase Array
  111. Solved: Data being reset when cell content is changed
  112. Solved: macro to print cell comments
  113. Solved: Assist. Placing Code in Correct Location
  114. problem with a macro
  115. TALLY MULTIPLE COLUMNS AND OUTPUT TO NEW WORKSHEETS
  116. delete umatched items from two seperate worksheets
  117. Should This Code Work
  118. Problem w/ block of code- Formatting Fractions
  119. Solved: Unprotect with input box
  120. Solved: Protection
  121. Solved: Last cell selected
  122. vba code.... change column width on selection of pivot table
  123. CheckBox and ListBox Problem
  124. Solved: Byref argument type mismatch
  125. Solved: Find and Replace *
  126. Copy Visible cells code
  127. Update Pivot table
  128. Image Preview
  129. text box
  130. tying cells together for automatic updating
  131. How to limit SQL right and left number
  132. Solved: Get data from sheet
  133. Amend Code -
  134. Extract data problem in the sheet
  135. Save sheet as a separate file based on cell vale of main sheet
  136. Which year in the period
  137. If two cells match from any given row then...
  138. Solved: Sum across worksheets VBA
  139. How to speed up loop
  140. Code to pick a workbook and add a code to it
  141. Solved: flaw in my code - creating a summary report
  142. Solved: merging worksheets based on unique identifier
  143. Names of cells linked to Control Sources
  144. Need help with an Excel VBA ado query
  145. Solved: Default file name in Save As dialog
  146. Macro to advance filter Data
  147. Solved: Onkey to insert symbols
  148. Solved: Trying to have text box in user form display cell contents
  149. If Problem
  150. Use the 2 colors to differentiate the Run File and Undo File in listbox
  151. FollowHyperlink problem
  152. Solved: Distributing data among sheets
  153. Main 2 ListBox problem into my vba program.
  154. Parameter query using excel range
  155. Solved: Userform Restart Sub
  156. use looping to replicate data table functionality
  157. Solved: display results only
  158. Error showing userforms
  159. ComboBox .List problem
  160. Solved: Quick question for anyone with VB
  161. Solved: Subscript out of range
  162. Transfer ListBox1.List to ListBox2.List
  163. Sheet Name Problems
  164. Solved: return value on column selection
  165. Progress Box
  166. Run Once @initial Startup
  167. Convert First Sheet in Workbook to PDF
  168. Solved: SaveAs Text File Changes Display Value: Stop This
  169. restore comannd bar .control
  170. Using sheet references in VBA on a VLOOKUP
  171. Excel file doubles in size
  172. disable an inputbox
  173. Changed Named Range of Chart
  174. Solved: Early loop exit
  175. Solved: UserForm questions
  176. Progress bar code help
  177. chart object change
  178. Solved: Same Value and SUM
  179. Validation Issue (Excel 2003)
  180. Solved: Workbook Code Module Excel 2007
  181. Kakuro
  182. Solved: Code is clearing clipboard
  183. Copy Range and paste it into a insert comment Part 2
  184. Excel ComboBox - Setting Value
  185. Reopened: Cell contents erased by user form
  186. Solved: Update a cell based on another cell.
  187. Solved: Balance 2 columns
  188. combo box
  189. merge ajacent cells
  190. Reduce size of Excel file
  191. Assign Custom Toolbar Button to XLA Sub?
  192. Solved: delete all sheets not in array(1 to 4)
  193. activate sheet
  194. csv to multi-column listbox
  195. Solved: Suppressing a message box
  196. Solved: Creating and naming a file
  197. Saving selected worksheets in VBA
  198. Error Message, Warning Message: List/Database
  199. Help: Dynamic Timeline Chart
  200. Send worksheets in body of email(outlook)
  201. Disable Virus Scanner Check?
  202. Custom Toolbar Help
  203. Solved: Add a comma after last name
  204. Solved: Search Excel data from JScrpt web page
  205. Not able to go beyond 9
  206. UDF to Calculate the Month
  207. Excel Sheet "Save As" Text File without altering active document.
  208. Solved: loop not working
  209. Time Tracking
  210. Using Access Queries in Excel
  211. Solved: Dealing with numbers with leading 0's
  212. Solved: detect which version of excel is running
  213. Solved: Bypass "Enable macros" warning
  214. Solved: How To Find "Max Value Of A Collection" ?
  215. copying data extact match vba code
  216. sumif across multiple sheets
  217. Solved: Clear cells in column A if column B has a zero
  218. Paste excel table into Word and then format?
  219. Solved: Moving data from sheet1 to sheet 2
  220. Solved: Help with Autoformat pls
  221. changing sheet tab colour
  222. Solved: Basic Question: EntireColumn Property statement
  223. Solved: application/object defined error when .IsAddin is true, but not false
  224. Run a Private Sub from a Keyboard Shortcut
  225. Solved: Install Add in and set reference
  226. Short cut keys won't run entire macro
  227. Solved: Quarter Hours?
  228. Formatting table in Word using Excel VBA
  229. Solved: Selecting the one row above with the relative range
  230. Copying Excel charts To Powerpoint via VBA
  231. Solved: How to initialize scroll bar w/o active object
  232. Relative scales
  233. Solved: How do I get the formulas to work on my userform
  234. Help with sorting data
  235. My first userform
  236. Copy and Paste data from multiple cells
  237. Stumped with XL 2007 Add-Ins Tab
  238. Solved: Create pivot table help
  239. Amend code - Important - Please
  240. Open text file and delete lines.
  241. Checking for Optional Argument
  242. Solved: Test if a Column Field Exists in Pivot Table
  243. Solved: The Macro "macroname" Cannot Be Found
  244. Read cell contents from a closed file?
  245. New to VBA - Importing data based on a cell value
  246. Solved: How Can I Disable A Macro from Another WB?
  247. Determine if a file has been updated
  248. Hyperlinked List of Directory Contents
  249. FSO Properties
  250. Userform Question