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. Solved: Get state of checkboxes
  2. Solved: userform textbox format for currency
  3. Solved: Formula property compile error
  4. Excel Creating an Email Error
  5. Open to specific location of worksheet
  6. Solved: Need help "Run-Time error 91"
  7. Solved: Lookup Intersection and copy column data into another sheet
  8. Populate combo box from selection of different combo box
  9. show popup of all sheet tabs
  10. Extracting data text and so on.
  11. Delete the row if cell contains null value else as it is ?
  12. Solved: Populating Combo Box With Values VBA
  13. Solved: Save Data Based on Vlookup
  14. compare two lists... and make changes
  15. Screen Flickers with screenupdating set to false
  16. Restricting access to a user to update a cell that is being updated by another user
  17. Solved: Userform Show/Hide Problem
  18. Solved: Date Picker default date
  19. Speeding up loop: deleting rows
  20. Solved: Extract Date
  21. Solved: Loop Through cells and sum
  22. Finding Holidays Formula
  23. Solved: Worksheet change event to populate timestamp
  24. Tabing issue in Combo box
  25. Solved: Formula Improvement - Hours * Rate
  26. Activate Method of Range Fails
  27. Solved: Looking up date and calculating monthly returns
  28. Solved: Counting based on 2 criteria
  29. Problem with SetFocus
  30. Execute diferent formula depending on cell value
  31. number format
  32. Help require in lookin for option button click event code.
  33. Solved: Setting default date in calendar
  34. Solved: Using A Date in DSum formula
  35. First Time VBA'(er?)
  36. Ticking Clock
  37. Solved: Select large array of non-contiguous ranges
  38. set cell value
  39. Solved: Pass an InputBox value into number of rows
  40. Initialize cell with mmult formula
  41. Solved: BIN2HEX Worksheet Problem
  42. Problem when using OFFSET
  43. Can we compare the Excel columns alone
  44. Solved: move sheets from specific files each time a macro runs
  45. Solved: named ranges
  46. Copy Entire Row if Column Value is Negative
  47. change formulas to
  48. Compare cells and highlight on a result
  49. Excel 2007 Populate table with web query
  50. Accessing files on webpage
  51. help with re-calculating Excel UDF
  52. Automation of Data Transformation and Consolidation
  53. Solved: How did I screw up Johnske's routine to force macro enabling?
  54. txtDate
  55. Inserting a row and moving a particular cell down one row
  56. PIvot Tabel macro no longer works since upgrade to Excel 2007
  57. Solved: Add Text to Old Call/New Call
  58. auto create text
  59. Copying to next empty row
  60. Help RC FORMULA STYLE
  61. Solved: Select Case with > 1 Variable
  62. excel vba to autofit row after cell update
  63. Excel and Access
  64. Solved: If/then statment where "then" does multiple actions?
  65. Solved: Before print function
  66. qty breakdown for inventory
  67. Setting the value of a cell to the value of a variable
  68. using sumproduct or sumif
  69. How to randomly choose sample rows after using Autofilter??
  70. lines in a cell or dropdown to next cell
  71. Tooltip Variable Values Vanished from VBE!
  72. Solved: Read Only: Disable opening/or disable prompt-to-save-as?
  73. How to Fetch Web Data into Excle
  74. Solved: for loop
  75. Solved: Insert Formula by VBA method
  76. Closing Excel & Opening Access
  77. Solved: Combo Box question
  78. 2 dimensonial lookup formula not working
  79. Formula in VBA problem
  80. Solved: Passing Variables from Sheet Code to Module Code
  81. Conditional Formatting & Reading Fill Value
  82. Compting 99% of a col range while autofilter is on.
  83. activecell.value - change from sub
  84. Removing duplicates with a difference
  85. Solved: .AddItme help
  86. New to VBA
  87. Solved: Editing Cell Comments Via VBA
  88. Solved: populate text box from combo box via vlookup function
  89. Solved: Formula to capture cell's displayed value
  90. Solved: VBA HTML - how do I access this button?
  91. Solved: Cell Interior.ColorIndex Property Changing
  92. Simple find?
  93. highlighting over due dates
  94. Vlookup from two cells
  95. Solved: Need Help : VBA in EXCEL / (if possible in DIAdem software)
  96. Conditional selection in excel VBA?
  97. Print Multiple Pages from DropDown Box using Macros?
  98. Multicolumn ListBox - Moving item upwards
  99. Adding Comments to a Formula
  100. Using VBA to create WordArt
  101. Solved: Determining Type of Data in a Column
  102. Test 3 spots
  103. Help! Macro to copy worksheet from different templates
  104. Vlookup from autoupdating master
  105. Solved: Insert Row every nth row
  106. E-mail attachment with VBA from Excel
  107. Counting Forward x number of months from given date
  108. Intersect function to find matching row AND column?
  109. Solved: Excel: Sumproduct or Nested IF statement help
  110. Solved: Worksheet Protection except Specific Column
  111. Solved: Remove first word in a string
  112. return column of change
  113. Solved: pivot table problem
  114. Excel 2007 Legend Border
  115. Have worksheet refresh only for changes in certain cells
  116. .Find and Dates..
  117. auto conversion
  118. File Chooser Needed
  119. Copy row data another worksheet in columns
  120. Get data from protected file, changes required in existing code
  121. Button macro
  122. Solved: VBA: 'Subscript out of range' Error ...
  123. Lookup on two values and copy cells when match found
  124. Solved: Need errorhandling for "print sheet" buttons
  125. Why does the path appears in some function formulas but not in others?
  126. Creating a standard form
  127. Solved: OFFSET and MATCH formula not working
  128. Filter data
  129. 3D Chart
  130. append color text (VBA)
  131. Activecell.offset
  132. Solved: Problems with creating a shift-plan for a new year
  133. Renaming not working correctly
  134. Auto Fill into Text Box / cell
  135. Need to know how to copy into next blank column
  136. Convert entity in excel
  137. Solved: Copying formula down used range
  138. Solved: Lookup Column A value and add Column X- then copy to other sheet
  139. Evaluating a string of an array
  140. Changing Colour Palette
  141. Solved: Resize autofilter
  142. Excel refresh page
  143. how to check if file is read only, but from other file
  144. Adding a,b,c letter to duplicates
  145. Verify that a Hyperlink successfully opened
  146. using wildcards in Formulas
  147. Find matching columns/cells and copying over data
  148. Passing data between a main code and an UserForm
  149. Folder Search File List
  150. Using if statements in PivotTable formulas
  151. Import range from closed excel file
  152. Solved: Search directory and return values
  153. ListBox Transfer Query
  154. Chart object fails
  155. Input Box/User Form
  156. Count Empty Range and MsgBox
  157. How to use ' to ignore large section of codes
  158. Format values copied and concatenated
  159. Run macro whenever you change sheets
  160. preserve regional settings when saving to xlTextPrinter
  161. Solved: intersection of named range and a column
  162. ODBC in VBA excel
  163. Solved: little sub that can MERGE
  164. how come temp files keep showing up
  165. Solved: Why is this not working?
  166. Solved: worksheet value change affecting 2 cells
  167. Solved: hiding Rows using index number
  168. Solved: Problem Launching Excel from Access with CreateObject
  169. Printing In Excel
  170. Solved: Delete Sheet In VBA Project Window
  171. Need comments
  172. Scrolling not working for TreeView
  173. Solved: Deleting Rows
  174. Solved: Inserting formulae into Used range
  175. Solved: locking VBA project
  176. ADO Version
  177. Pivot Table - Getting Correct Profit %
  178. Solved: (VBA) Recursively list files and output to csv
  179. referring to numbers/alphabets
  180. Solved: Timing a For Loop
  181. Using 'IsNumber' in a Select Case
  182. excel save as csv
  183. Sorting a table
  184. Absolute value
  185. Solved: Copy the text from WORD to EXCEL
  186. save sheets as new version: changes required in existing macro
  187. Pivot Table Stored Proc with Parameter
  188. Solved: Data Validation list based on a filtered list.
  189. Auto sort consolidation book
  190. Solved: Copy rows from one worksheet to another with some condition.
  191. Delete Row if Cell Contents = "ABC"
  192. Not able to access input boxes on a web page
  193. Solved: Error::Can'tDeclare Array as 'Public' ::What is Excel's Problem now?
  194. Hyperlink to Search Folder for a Number
  195. Solved: Instr & bold
  196. Referencing worksheet name using code name
  197. record and play macro to create commandbutton gives different results
  198. Switch off subtotal on pivot table
  199. Copy Paste of Filtered data with hidden columns
  200. Solved: Percentrank :CSE
  201. Delete Macro
  202. Trouble with pasting a formula
  203. Loop OK manually, but "freezes", when run with DDE update
  204. Solved: Macro won't run
  205. Copy & Pasting in VBA
  206. [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA?
  207. Placing data on a closed excel file in Sharepoint
  208. Checking each cell in a row
  209. Extract string within tags
  210. Update excel record to existing DBtable
  211. Solved: need help for ranking a list
  212. Solved: How to check if user has PI tag addin if not add it?
  213. How to update a list to fill combobox
  214. Do Update only Loop, NOT again from start Sub with DDE link
  215. Solved: can you get vba to declare variables based on an argument passed
  216. Solved: excel vba book recommendations
  217. Change sheet to PDF & Delete Sheet
  218. Solved: Creating a look-up and complete macro
  219. Solved: Repeating Rows at the BOTTOM
  220. Solved: Find last row and set range name programmatically
  221. Solved: VB control of IE Dialog box
  222. Help with For Loop Structure
  223. Click listbox and Show picture
  224. Wanted: Testing and feedback of Duplicate Master addin V2.0
  225. Solved: Forms with hyperlinks
  226. Solved: VBA coding help
  227. Open File for Output:: What if file does not exist?
  228. Having problems trapping error 76
  229. Solved: Dynamic Drop down list based on filtered list
  230. Solved: Find records and return values to new column
  231. manipulating Excel's "Normal" style
  232. Script out of range error
  233. Solved: recursive sheet deactivate event
  234. Listbox with zero entries
  235. VBA to convert .exe
  236. a word of thanks to all those that help in this forum
  237. How to show Detail Box
  238. Excel - WebBrowser Control - Vista/IE7
  239. Solved: Detail MsgBox
  240. how to highlight the first value in a listbox
  241. Solved: convert number to text
  242. verify text of IE
  243. Comparison on 2 sheets base on a unique name
  244. application defined error - VBA
  245. Solved: Create folders if don't exist
  246. open a new instance of Excel
  247. Userform On Website?
  248. fill column when a row criteria was satisfied
  249. Solved: Probably not the right tool but...can Excel..
  250. delete spaces