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