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 168 169 170 171 172 173 174

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