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

  1. Trial Code Error
  2. can't get caluclate event to fire vba
  3. Search and Replace Macro
  4. User form OHR and Password break.
  5. macro search
  6. Lookup value in Table
  7. Extract data from MS Access table using excel macro.
  8. Rand() in excel 2000
  9. How can I put multiple codes in 1 sheet?
  10. Picking only records based on po #.
  11. Time capture activity require.
  12. Solved: How to Delete Data on the other sheet using VBA?
  13. OLE created workbook vs User Created
  14. Solved: stops all other macros except this one
  15. Solved: Test if Folder Exists
  16. Check box question
  17. Solved: Selecting Row with variable
  18. 'merge' sheet and adding new sheets; shname()
  19. how to Delete Data Row with use of VBA code
  20. Solved: Protect and unprotect worksheet change
  21. initial value for listview from excel
  22. Automatically Update/Populate Listbox based on selections of other listbox
  23. Solved: Enter a cummulative value into a cell
  24. Copy and Paste in Filter
  25. Copying rows in range based on criteria
  26. emailing cell range
  27. How to only keep duplicate values
  28. Save to new workbook and delete a specific sheet
  29. Solved: find the letter for the last colomn
  30. Solved: VLookup in VBA
  31. Solved: ISERROR VBA CODE
  32. Solved: Formulas are not being copied correctly
  33. Solved: How to delete columns that go through an area with merged cells
  34. Solved: Multipage/Treeview Expansion problem
  35. Solved: Working with a Filtered Dataset
  36. External Formula
  37. Solved: put a range into a variable
  38. Min,Max,First and Last Values within Time window
  39. hiding formulae in excel 2007
  40. Solved: Changing Arrays
  41. Solved: populate multicolumns of listview
  42. VBA - Dodgy IF statement results from certain numbers
  43. How To Write Find Function Using Macro
  44. Solved: Insert Rows, AutoFilter, xlCellTypeVisible
  45. working with ranges of merged cells
  46. Copy/Paste if cell contains "123" characters
  47. SaveAs and Fileformat
  48. A faster/more efficient way?
  49. Solved: Run Macro on Cell Change
  50. Scanning data series and plotting based on data
  51. Solved: Combining 1 Cell from sheets into List
  52. Delete Rows when Condition is met
  53. remote update of code
  54. Solved: Clear Contents on Workbook Close
  55. Solved: Does VBA need a pause inserted
  56. Adjusting macro to loop through criteria
  57. What are CUBES when used in Excel
  58. Solved: How to show a Calendar in Combo cube dropdown on a excel Userform.
  59. highlight specific cells in active row/column
  60. Using a case statement
  61. public object module error
  62. Solved: Questions regarding Excel vs VBA
  63. How to define workbook is open in which process
  64. How can i plot a Graph on Microsoft Excel?
  65. Solved: Need help exporting data based on listbox selection
  66. Save Excel using VBA
  67. Solved: Auto open macro help
  68. Solved: Add negatives?
  69. Solved: Similar case
  70. Solved: Listbox Related Question
  71. Solved: Combobox data to listbox or textbox?
  72. Data mapping from one excel workbook to another excel workbook
  73. Solved: Create backup to another location
  74. How to filter data with a multi-selection listbox
  75. Solved: IF Statement Limit Reached
  76. Solved: Delete zeros
  77. Filter not work with xl2007?
  78. How to colour an entire row, on row number click
  79. Solved: referencing specific worksheets in vba
  80. Number format of cell which contains formula
  81. Solved: macro to Delete entire row based on a criteria.
  82. Solved: macro to replace error formula cells in a column with some other text or number.
  83. Solved: A macro to saveas a worksheet as a new workbook
  84. Solved: Accessing specific sheet by password box
  85. cells contain hidden values
  86. Excel Status bar will not update
  87. how to open a existing worksheet from certain folder and creating new workbook
  88. sort columns via listview
  89. Solved: lookup function in VBA
  90. VBA script in excel! help
  91. Solved: If Esle..If VBA
  92. Solved: Unexpected error.
  93. Costing schedules
  94. Solved: Finding Last Visible Row
  95. New worksheet using template based on cell values
  96. At a loss for direction..
  97. Poll of numbers HELP!
  98. Computing 99% of COl M while cell is in filtered mode.
  99. Analysis of Amount based on following criterion.
  100. Solved: Changing Text in Buttons
  101. Copy Cell From Workbook and Paste to Another Workbook's Cell
  102. Solved: Referencing Another Sheet in Workbook
  103. Inserting a row or a column
  104. Next row down
  105. =OFFSET(EntrySht!$B$9,1,0,COUNTA(EntrySht!$B:$B)-1,1) working functionality require.
  106. Deleting the row that contain the text " Dismantle"
  107. line breaks & spaces
  108. Solved: Finding the Correct Value
  109. accessing gmail attachments
  110. Checking ref # status based on sheet2 ref #.
  111. Excel 2003 question ( using If )
  112. Solved: Where can I find a VBA guide?
  113. Excel 2003 VBA help
  114. How to copy different excel worksheets in one workbook?
  115. Solved: IF/ ELSEIF Help
  116. Solved: list data from 53 sheets
  117. Solved: 2 sheet search
  118. Solved: Sort Question
  119. Run Time Error 1004
  120. Solved: reference to a sheet
  121. Filter date from multiple Pivot tables
  122. Function or UDF
  123. Formula Help
  124. Best Place for Subs
  125. Solved: Excel AutoSum
  126. Solved: Auto Protection
  127. If filename is in sheet, return true/false?
  128. Finding the difference of two dates based on criterion.
  129. Automatically saved into the drop-down list and show edit comments
  130. Hiding column need to be unhide.
  131. Solved: Help on alpha numeric subraction...
  132. Speeding up a loop, that does an action when encounters a value
  133. Solved: Call Sub Help
  134. Groupwise attachment loop
  135. Problem with coding Sub
  136. Solved: Excel Formulas based on Lowest cost
  137. Solved: Update records without looping?
  138. Arrange columns of names & addresses into rows
  139. Need to test if Worksheet Name Exists
  140. Formula VBA Help
  141. Solved: Play .wav sound file when userform opened
  142. Solved: Error: 1004 - Application-defined...
  143. Solved: How will I modify a VBA code that will only calculate the last populated row?
  144. How to get currently logged on user's account name?
  145. Solved: .Copy Destination (Error)
  146. Problem with Date Filter between two dates
  147. Solved: How to troubleshoot error on my macro?
  148. data fram pdf
  149. Trim bug?
  150. Email macro stops after sending first email
  151. Solved: Extract data from text file
  152. Solved: How to open sheets as hidden
  153. Sorting and removing duplets
  154. executing T-sql stmts in Excel VBA
  155. Copy Records to Worksheets based on value
  156. display records by office
  157. Activate Excel Window
  158. Solved: Hiding Cells
  159. A rather nasty COUNTIFS statement issue
  160. Dynamically change size of Array
  161. Solved: Do a .Replace on an inactive sheet
  162. Need help with events in HTML Table - Excel 2007
  163. Solved: Write number as string
  164. display records by office
  165. Solved: combobox on the fly
  166. download file
  167. Help needed on variable workbook name.
  168. Solved: How to protect your VBA codes?
  169. Solved: How to change color of Form Control Button?
  170. Refining ListBoxes
  171. How do I do a best fitting line on Microsoft excel?
  172. Need help with MkDir form Cell
  173. Printing all worksheets in a workbook as a single file..
  174. Solved: Help needed with VBA for Alt+F11
  175. Solved: Drop Down Box -
  176. Solved: I want to add a textbox on the chart
  177. Excel Look up data in a access database
  178. VBA and cell references
  179. How to parse HTML file from VBA code into Excel ?
  180. Solved: Cell Reference
  181. Solved: Use of AddShape to add circle
  182. Object visibility?
  183. Resize Pictures
  184. Solved: Looping Goal Seek Function
  185. UserFrom ListBox FilterInPlace on inactive sheet
  186. Solved: Import External data into Excel
  187. Delete a worksheet without losing Formula reference
  188. Solved: looking for the correct sheet and fill in the value refer to date
  189. Problem saving as macro-enabled workbook
  190. Excel to open and run Access Macro
  191. Solved: Pivot Refresh Problem
  192. Delete rows if cell less than 4
  193. How to remove the blank space which is present at the end of the value in a cell
  194. Solved: how to stop duplicat data entry
  195. Solved: Password entry visible
  196. ByRef ByVal
  197. Multiple If statements with multiple date range
  198. Solved: If / Statement
  199. Select multiple rows based on selected column
  200. Solved: VBAProject (PERSONAL.XLS) Stays Open Forever?
  201. Solved: Keep common inputbox in background
  202. Solved: Can This be Simplified?
  203. Solved: Worksheet ListBox Selection
  204. Populating a Userform Textbox on userform open!
  205. Macro required for ALT+TAB keys
  206. Solved: Count weekly offs based on day of week
  207. loop to delete the row and replace the value in cell having problem
  208. Listbox selection and deselection triggers in userform
  209. Multiple selection from the cell.
  210. Solved: Unlocking several VBAProjects
  211. Delete the warning message.
  212. Solved: Division with remainder
  213. Use VBA to populate a VLOOKUP formula - then move that worksheet to another workbook.
  214. manual recalculation not for all sheets in wb
  215. Solved: UserForm List Box Problem
  216. excel multiple workbooks
  217. Case Statement
  218. Combining multiple excel workbooks in to a single sheet
  219. Solved: Protection Issue?
  220. Solved: Delete Row Skipping
  221. Hide "View" menu
  222. Comparing cells within a column
  223. Process bar
  224. Solved: Populating a listbox
  225. How to open workbook in another computer
  226. Solved: Input/Output text files fill in variables
  227. fill in the value accoding the date
  228. Solved: How to formulate sumifs based on weeknum?
  229. How to attached font when save Excel 2007 into Excel 2003 format
  230. Sending email from within Excel (.From) issue
  231. Data from Excel (macros) to Word using VBA
  232. Solved: Delete row
  233. Unable to get the SaveAs property of the Workbook class
  234. expand selection starting from dynamic range
  235. Hiding rows in a function
  236. Solved: VBA Code - Adding value to Comments
  237. can i define the Public contant WB and Sheet name for use in form ,macro and sub?
  238. Solved: prevent worksheet deletion.
  239. Solved: loop through selected cell
  240. How to use AutoIt to Open Excel and Enabe Macro
  241. Solved: counting
  242. Solved: is there a paste special for this data?
  243. Solved: Changing d/m/yyyy format in workbook
  244. Solved: Word Constants
  245. Solved: auto-fill webpage search form
  246. Query regarding worksheet function (Count IF) using in Excel VBA
  247. VBA - Populating Arrays Inside of Structures
  248. Solved: Hide columns not appearing in Sheet 3
  249. VBA Project help and overflow error
  250. Solved: Transpose table of data