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

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