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. [SOLVED:] Function to wait until a particular file exists
  2. Excel reversing cell value?
  3. Extract One column from multi-column array
  4. Solved: Pease help on CTRL-SHIFT ENTER on my VBA Formula
  5. convert xls to csv large number problems
  6. SpinButton
  7. [SLEEPER:] Something weird with vba
  8. [SOLVED:] Get a line from a text file.
  9. Solved: Move numbers from DOC to XLS
  10. Solved: Find Duplicates
  11. Please help with my Pivot Table VBA Code.
  12. Solved: make certain cells visible
  13. Help regarding reminders about birthdays of employees in advance(2days)
  14. IF formula for identifying unique rows (quite confusing problem)
  15. Feedback form Help
  16. Excel save file - 2007
  17. Simple Copy and Paste Mystery
  18. VBA not working on both sheets
  19. Module to delete rows
  20. update data via listbox
  21. Conversion and Icons
  22. [SOLVED:] SpecialCells(xlCellTypeVisible) does not seem to work in range object
  23. [SOLVED:] Tabbing order
  24. passing FieldInfo value as a variable
  25. Solved: The magically disappering Excel Workbook.
  26. Using VLookup and Maximum statements or what will work
  27. Solved: Sumproduct - Summing
  28. Hiding Rows takes Time
  29. Solved: Removing a Item from Listbox.
  30. Self-saving workbook?
  31. Help with Create Hyperlinked List of Directory Contents
  32. VBA - Format with lanuage change
  33. Solved: Microsoft Internet Controls Library
  34. Help using Access as backend for Excel
  35. Solved: Copying an entire Letter from word document
  36. Solved: Formula to help identify specific words in titles?
  37. [SOLVED:] Time difference formula required
  38. Solved: Help with value testing
  39. Solved: creating recap with macro
  40. Solved: countif - help required
  41. Printing daily log sheet with preprinted dates (solved)
  42. copy entire column and paste into another workbook
  43. [SLEEPER:] Weird insert line problem...
  44. AUTOMATICALLY CLICK DEFAULT MESSAGE BOX
  45. Solved: Removing duplicates based on two columns
  46. Help with the Loop
  47. Help... What have I done !!
  48. Autofilter code not working
  49. Workbook Sequencing Only on Saves
  50. Solved: How to copy formatted number cells visible text?
  51. Solved: Sumproduct calculating total incorrectly due to date
  52. Searching within a pivot table
  53. Eventdriven XML Export
  54. need help with rounding formula
  55. Pointer to Workseet
  56. Solved: Form VBA
  57. Solved: Is there a way around using a tonn of ascii references......
  58. Operators in Arguments question
  59. Creat Pivot table by VBA
  60. Macro 4
  61. Loop through variables
  62. Solved: Search for cell values then sum scell to......
  63. Solved: parse and new column
  64. VBA code to enable autofilter on protected sheets
  65. [SLEEPER:] Populate ListBox with Filtered Records
  66. Solved: lost vblf's
  67. Solved: Problem with date Picker Control
  68. Solved: Problem in Find & FindNext for a Function call
  69. Solved: copy worksheet to another workbook
  70. Code moves cells out of range
  71. Save to SharePoint Library w/meta
  72. Change 1 character in cell
  73. [SOLVED:] Call every X seconds
  74. Transpose or array?
  75. Change Customer ID
  76. Solved: syntax: shell
  77. ActiveX in Excel
  78. text box
  79. find and compare
  80. Solved: Command button colour change if file missing
  81. Solved: Active cell display
  82. Weird Type Mismatch Problem (Cell Formula vs. Cell Value)
  83. Runtime Error 1004 with working accross worksheets & string concatenation
  84. How To separate VBA application into file
  85. Get a Structure from a Pointer
  86. Button embedded in a chart, xl2007
  87. Solved: User defined function and copy paste
  88. [SOLVED:] Help with MsgBox Function
  89. What Does “Insert Names” Mean on the VBE Screen?
  90. Run a macro contained in an add-in using keyboard shorcuts?
  91. plotting a named range within a named range
  92. Solved: Find in 3 colums and list the result in a list box..
  93. Completely at a loss...
  94. Solved: combine from all sheets
  95. Problem with Excel - Access macro
  96. Solved: Cells showing as formulas...not results.
  97. Text to Columns Wizard - Way to save off positions?
  98. Solved: PRINT AREA VBA
  99. Animated Gif Help
  100. Solved: How to copy rows in different worksheets created on the fly
  101. [SLEEPER:] Lock cell formatting but allow value input
  102. Solved: Remove All Comments
  103. Solved: multi columns selected
  104. Solved: Tracking changes with comments
  105. Macro to export cell values to Word
  106. Moving ExcelMacro to Access
  107. Get Data From Acess
  108. Solved: Cell reference in VB
  109. New landscape Word doc from Excel
  110. Open Publisher doc from Excel then edit
  111. Obtain version number of SharePoint document
  112. Solved: RecordSet and ListView
  113. Managing Duplicate Conditional Formatting Rules in Excel 2007
  114. Solved: Check 1st 4 chars & conditionally enter a string
  115. Scrolling issue, going too far
  116. Solved: vba to ID info in cells and find other cells with same info
  117. Pull data to new workbook with new sheet per workbook
  118. Search folder with a value in cell
  119. Button press effect in Excel Shape
  120. Solved: Seperate each recipient into own tab
  121. Solved: Excel match headers, append data
  122. Copy Folder to specified path...
  123. Automatic upload excelsheet (html) to web
  124. Solved: User Changeable File Paths
  125. Solved: Check if combo box is populated
  126. Solved: Limit character input in a textbox
  127. Solved: how can i change this code to identifiy the 2 digit no?
  128. comparision macro is very slow
  129. Solved: Problem with amended xld.sheetmanager code
  130. Solved: Deleting Rows based on criteria
  131. Solved: Buttons
  132. Solved: import empty column QueryTables thnks
  133. Solved: Condionally Formatting a Row Based on a Cell Condition
  134. Solved: Count unique entries that occur over consecutive dates
  135. Solved: Scrollbar
  136. Solved: Monthly to Quarterly Part 2
  137. Copy a table from an excel sheet to an Embedded Excel Chart Object's Sheet
  138. Runtime error '1004' Application-defined or object-defined error regarding if formula
  139. Solved: Can't get If,Or, to work
  140. Solved: Copying Named Ranges
  141. Solved: Changing time string?
  142. Solved: Adding a New Toolbar
  143. Solved: Formatting Dynamic Toolbar
  144. Solved: extend the border line
  145. How to acees server xml file
  146. Solved: Sum the distinct values under a specific criteria
  147. Solved: User Input With Options
  148. Library Not Registered error
  149. custom order?
  150. Copy Worksheets to a new Workbook
  151. Solved: faster way to delete row
  152. Save Data to a Closed Workbook.
  153. Solved: Cell value capture
  154. Getting Week Numbers to Display over Multiple Years without Resetting to 1
  155. Any of you guys familiar with web query...
  156. how to find last non empty cell in col and use it as input in a range
  157. Populate a field on a webpage and submit and record data
  158. Solved: Making CheckBox1 Selected By Default
  159. Preserving Objects and Collections
  160. Command Button Shrinkage
  161. Solved: VLOOKUP accross sheets
  162. Solved: Calling a Script From Another Module
  163. Changing CommandBars.Name
  164. VBA programming question on cell selection and optimization
  165. Help reg user form development
  166. Solved: Insert picture
  167. Interactive Drop Down List/file chooser
  168. Solved: If value found, copy range macro help!
  169. Solved: special sort
  170. Match columns linked to external workbook
  171. Solved: Colour change based on cell value
  172. Simple Copy and paste
  173. Using a click button to select data relating to checkboxes
  174. Sub routine isn't sending outlook message..
  175. Solved: Copy .txt file
  176. Solved: Sound alert
  177. VBA for batch upload
  178. Help with VBA code
  179. Solved: Error with Recorded Macro
  180. Solved: Time format in user form
  181. Solved: Format Chart Area
  182. I/O Excel to PicAxe Micro
  183. Solved: Looping through Worksheets and inserting a formula into a Range of Cells
  184. Solved: How do you create a quiz with microsoft excel 2007?
  185. How to escape characters in Microsoft Excel, such as an equals sign?
  186. Solved: Method "FileSearch" Problem
  187. Solved: Copy data from 1 workbook into another
  188. Solved: How to add new range in the VBA
  189. counting results from searchareas.
  190. Solved: Pulling Value Only (not equations)
  191. Macro To Merge Data from Different worksheets
  192. Solved: Please help tech wizards!
  193. Solved: listbox items as variables
  194. Solved: A list of distinct values
  195. Sleeper: Collection Class - Item Method
  196. Highlighting Duplicate numbers in excel only when they are next to each other
  197. Solved: OpenText Method: Excel remembers Last Import!
  198. Solved: Lookup Help
  199. Populate List Box in Excel with visible rows when worksheet gets filtered
  200. Solved: moving array to worksheet
  201. Solved: caclulating birthday in a userform
  202. Solved: Loop through a range and hide active Column
  203. help me plz
  204. Solved: Looping through autofilter, copy, paste
  205. How to improve the performance of this code
  206. Solved: Loop OpenText function
  207. Macro Help
  208. Excel wants to talk to Access
  209. Entering Selected Cell Values in Multiple Textboxes
  210. Solved: Change code to choose .txt file already open
  211. Checking existence of a text in SQL database table column.
  212. Paste Data From Excel To Access
  213. Solved: Is there a shortcut for this code?
  214. Solved: Remove last 4 rows from a listbox...
  215. Can't Exit Design Mode because 'ControlCommandButton1' cannot be created?
  216. Solved: Convert to Propercase Selectively
  217. Move multiple sheets from multiple files
  218. Creating dynamic Range for combobox
  219. Solved: VBA Web Query to google finance/reuters
  220. FORMULA FOR REPORT IN EXCEL
  221. From Excel to XML via VBA
  222. Solved: Test for Existence of Toolbar
  223. [SLEEPER:] Using VBA to move the mouse to a specific coordinate and left click?
  224. Solved: Add ListBox item if item exist just once...
  225. Solved: Disjointed Information to Table (Solved)
  226. Solved: copy defined rows
  227. Solved: Clicking CANCEL After Executing a Command
  228. Making graphs in loop
  229. WebBrowser Control with Animated Gif
  230. Transfering data from UserForm to specific cell
  231. How do I put Msgbox in between formulas in VBA?
  232. Open a workbook with a long file path
  233. Copying to multiple workbook coding..
  234. Solved: Extract distinct list from a range
  235. Solved: Scanning Program that converts document to excel
  236. Sub Returning Workbook
  237. Help with Variables in Ranges
  238. Unloading User Forms
  239. copy selected cell with links
  240. How do you create a VBA formula code based on Filename?
  241. Group Variables together
  242. Solved: Help with Objects in a Collection
  243. [SOLVED:] Prevent Function calls in worksheet when running macro
  244. Solved: Open and Close File
  245. Solved: Looping with textboxes
  246. Form Button Font Keeps getting smaller
  247. XP Visual Styles to Excel UserForm
  248. Solved: Macro for printing
  249. Macro to save file with active cell value with 3 date options
  250. Method to merge two excel files without links