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. combobox change event loop
  2. Solved: Help with Checkboxes and OptionButton
  3. Combine
  4. Solved: problem in opening a specific filename
  5. Compare 3 Columns and Return all Matches
  6. Solved: CSV to ASCII
  7. Unzip code error
  8. Solved: ClosedWorkbook/Filter
  9. [SOLVED:] Copy cell from diferrent workbook
  10. Solved: Hide columns
  11. Syntax error
  12. How to create a macro that will produce a csv file from a button
  13. Solved: Commandbutton visibility
  14. Solved: Copy cells + manual input!
  15. Solved: opening a file using textbox and combobox as the destination path and filename
  16. Solved: summed one, two or more textboxes in mathematical way
  17. Opening files in a folder with a certain word in filename
  18. Solved: Cell Protection
  19. Solved: Close excel if last open workbook
  20. Solved: Problem starting app from Range
  21. Solved: Code makes excel crash!
  22. Run-time error '9' Problem
  23. Solved: How to refer to a range?
  24. Open then Close Workbook with userforms
  25. Need code for automated summary
  26. Error
  27. Excel macro help
  28. Autofilter Macro with 3 criteria in 1 field
  29. How to pass a part of a Nested Array to a function?
  30. [SOLVED:] Getting a filename Into a cell content
  31. Solved: independents from system separators
  32. Solved: Help with Formula please
  33. Solved: Load data into TreeView
  34. VBA Excel Macro Copy/Paste Rows
  35. finding active inernet url
  36. Solved: Counter Number Non start with 1
  37. Selection of sheets to run VBA routine
  38. Solved: how can change the same data raw selected in ListBox?
  39. Summarize data
  40. Solved: Drop Down Data Validation - Quirks
  41. How to do this?
  42. Web query and 'splash' screen
  43. Solved: Copy Data from One Sheet to another if cell is NOT empty
  44. Specify the position of a Minimized Userform
  45. Solved: loop through named area
  46. File.Search Alternative for Excel 2007
  47. External Data SQL Server & Destination
  48. Web query VBA
  49. How to locate nth Visible cell in the filtered columns?
  50. Solved: Import Class file from Visual Studio to Excel
  51. Find And Replace - Excel 2007 - VBA
  52. Solved: Copy Values and Formats to a new workbook VBA
  53. Solved: Check if workbook is open or is active workbook
  54. Solved: 2 VBA-Projects named the same after saving/opening file
  55. Solved: Activate open workbook
  56. Solved: Macro to Hide Columns Based on Options?
  57. Solved: clear contents based on conditions
  58. macro Code Short Cut to Hide Column
  59. Solved: Send Email with a link to the Excel file
  60. [SLEEPER:] macro calling another macro
  61. Search Range and Delete any Blank Rows
  62. split one column to three column in other sheet
  63. Solved: Call to other sub within a sub
  64. Procedure dependable on multiple constants?
  65. Generate / Create PDF using VBA and Password protect PDF
  66. Solved: Need to append todays date as text to the end of the selected Cell Text
  67. Solved: Need to sort Excel by Colored Row, and Cell values
  68. Solved: Forcing User To Enable Macros
  69. Solved: Maing sure xlCalculationAutomatic = true
  70. Solved: Excel2003 - Hide Col2 in Sheet1 & Sheet2 Very Hidden, if Workbook Opened as Read Only
  71. VBA Save As with Password
  72. Solved: scheduled task question
  73. Solved: Excel macro for "=sum()"
  74. Running macros after converting excel files to exe files?
  75. setting dynamically
  76. Solved: Run time error 91: Object variable or with block variable not set
  77. [SLEEPER:] How to find an object's type?
  78. How to set an object type dynamically?
  79. Screen updating with textboxes/labels
  80. Solved: delete rows without open files
  81. copy form one WB and paste in a different WB
  82. Hyperlink to another sheet
  83. Deselect Object
  84. Solved: vlookup for part of word with separator
  85. Positive
  86. Not able to retrieve historic values - link updating issues
  87. Sum data if week number is <= current weeknumber
  88. Prevent duplicate entries in two sheets
  89. Solved: Deleting blank spaces in front and after a number in a cell
  90. Userform - Copy active row and move to last row
  91. [SLEEPER:] Return "0" instead of "N/A" in Pivot Table reference
  92. Excel VBA Automation of Internet Explorer
  93. Denying a cell to be changed in any way
  94. Solved: Force close
  95. Solved: Modifying the Search to include Searching in another worksheet
  96. running count if total
  97. Solved: Unwanted hiding of a column
  98. Autofilter in VBA for selected string in a cell
  99. How to get information from a ListBox to an Excel Worksheet
  100. Hooking LIstBox in Class Module
  101. Force fullscreen mode
  102. Syntaxes for Worksheets and RC formula
  103. Solved: find values separated by a slash
  104. Modifying Data on Another Worksheet
  105. simple chart with 2 yaxes and 1 x axes
  106. Tab Error on CSV File
  107. Selecting a range for a barchart in vba
  108. Solved: index, match
  109. Delimiting a cell to the rows below
  110. Formula or Macro? Help
  111. Solved: Find the words &quot;*-*Shares&quot; from ColF and move to ColG
  112. Cannot Insert Object
  113. [SOLVED:] Compare a cell with another cell
  114. Solved: How to find subtotals from formula currency converted cells
  115. Solved: extracr specific data from a file
  116. Solved: Modifying Data in a Worksheet from a Userform
  117. Solved: Hiding 120 tabs
  118. click a button to open a picture
  119. Problem installing Format Functions add-in
  120. deny changes after entering data
  121. Solved: Vlookup/Match
  122. double vlookup
  123. Need Help with controlling internet using Excel Macro !!!
  124. ExcelDiet
  125. Help plotting a graph in VBA
  126. Solved: Creating folder
  127. Find all function returns the cell or the value?
  128. ComboBox crashes in 2002, SP3 but works fine in 2010
  129. Consolidation of various files based on cell value/Filter
  130. Send Mail range to each person
  131. [SOLVED:] Read Only Prompt When Saving
  132. Keeping Cells that are Conditional Formated when Sorting Data
  133. User Defined Function and calculate
  134. Inserting pictures and the path.
  135. Solved: Statusbar black on black
  136. how to reset the value of .FileSearch to null or nothing?
  137. What is the MaxLocksperfile property?
  138. set y = “the row number” at which the button I click locates
  139. Solved: New to VBA
  140. copy sheet based on list of names once only
  141. Solved: deleting specific words from a cell
  142. Nest do loops
  143. Find and replace tab names
  144. Solved: How to return a worksheet name based on found data
  145. Solved: Paste from Excel to Word
  146. How to Hide Specified Cells?
  147. Force save another open workbook
  148. Solved: using macro to edit macro
  149. Solved: Number fill - randomly
  150. Master Workbook linked to Two Workbooks
  151. Create a block diagram from text
  152. Upload using VBA to a Google Sites Filing cabinet
  153. Moving Data to Another Worksheet
  154. Undead Data, or: what's a "block of data", anyway?
  155. Sleeper: Internet Explorer Form Automation
  156. [SOLVED:] Deactivate Commandbutton and Hide
  157. Deleting a Record from a Worksheet
  158. SUMPRODUCT
  159. Solved: Close Worksheet Macro
  160. I need a simple code.
  161. Update Sales Territory Shifts/Changes through VBA
  162. Solved: Make a chart from 1 column
  163. [SLEEPER:] Check if userform is visible
  164. Solved: Data Validation
  165. Simple Sheet copy problem: Workbook to Workbook
  166. Data Input Restrictions
  167. Solved: just values insted formula
  168. Opening UTF-16 text file with VBA
  169. How do i Copy numbers only.
  170. Unwanted change of font while pasting into Word
  171. Solved: Excel’s Speak Cells feature
  172. Solved: Value Function
  173. Grouping cells so that they can be sorted together in excel
  174. Solved: Activating Java table with Vba
  175. Combining OFFSET and VLOOKUP
  176. Identifying pdf charts by VBA
  177. Code for formatting Email from Excel
  178. Cmd button for Redo Function
  179. Solved: Upload file into website
  180. Solved: Compare/replace based on equivalence list
  181. Solved: Combine cells values from two sheets into 1 cell
  182. Check FirstName&LastName duplicates
  183. [SOLVED:] Compare/Copy new location. Isn't working!
  184. Solved: vlookup:Search from bottom row instead of top row
  185. Solved: Excel 2003 Change Event to concatenate Column 8 value to Column 12 Value
  186. Solved: Excel 2003 How can I delete a specific shape type within the ActiveSheet
  187. Solved: cell contents were missing once i reopen a file
  188. Solved: print code
  189. Read out - VBA
  190. rMOVE ZERO
  191. How do you merge workbooks into one complete spreadsheet.
  192. Solved: Data Validation - Formula Question
  193. Solved: Change Default Font for New Workbook
  194. Goal Seek for multiple rows with blanks between them
  195. Solved: Using Variable Col_Index with VLOOKUP
  196. Sum multiple lines based on multiple criteria
  197. Solved: Drop Down List
  198. Solved: Hide worksheets
  199. [SOLVED:] Code for pushbutton click
  200. Solved: Copy current data to a new sheet....
  201. Solved: Excel 2003 - Need to change the value in cell that contains a specific autoshape
  202. Solved: Excel Form
  203. Fix excel error "Too Many different cell formats"
  204. Solved: Excel 2003 - Need to sum numbers that are in cells formated as text
  205. Solved: Excel 2003 - What is the Cell Character limit? And why do I see #### in the cell?
  206. Solved: Autofill, last row in column
  207. Getting/Searching Cell value from another Excel Worksheet
  208. COUNT AND FILTER
  209. Solved: Countifs Help
  210. Solved: sorting by cell icon
  211. Condiitonal formatting dependent on a Comment
  212. [SOLVED:] Quick table lookup
  213. Kindly help me write these excel macros
  214. Solved: Excel Caption
  215. Solved: Excel 2003 - how do I Auto Fill a Formula down to the Last Row in a Column?
  216. Solved: paste to non contiguous named range
  217. Solved: Excel 2003/2007 - Need to delete top and botom row borders after selection change
  218. Solved: Excel 2003 - Highlighted row using top &amp; bottom borders. Would like to speed up code
  219. List of Folder,Subfolder & filename
  220. Solved: 4 letters
  221. Solved: Extract and find
  222. Using VBA to insert or delete row and column automatic
  223. Hi. Need help creating/saving workbooks.
  224. Solved: Output Data from a Userform to a txt file
  225. pagebreaks
  226. Help with Error 91
  227. A continuation... Question of method...
  228. Solved: Counting weekdays
  229. loop, if and empty
  230. CONCATENATE
  231. [SOLVED:] ADO Connections
  232. Finding and Moving Cells
  233. search replace Diogonally
  234. [SOLVED:] Less specific search
  235. Solved: Excel 2003/2007 - Need to trigger the change event if new row is inserted, or deleted
  236. Solved: Excel 2003- Can a formula in a cell detect how many rows are above it?
  237. Remove Contents of a cell based another cell's change...
  238. Solved: Preventing undesired jumping of mark
  239. Error running Word from Excel
  240. Solved: Event Macro to trigger if a query should refresh or not
  241. Solved: Excel 2003 - Is there a way I can speed up my AutoFill Formula for 15,000 rows?
  242. Solved: msg box then deleting field when cell changed
  243. Copy Pasting from one workbook to another
  244. Graphs: Return null value.
  245. Copyingmultiple worksheets
  246. Trial some VBA CD burn code
  247. Fill combobox from different worksheet
  248. Solved: Color banding
  249. scrolling text on a form
  250. Solved: referencing a tab name in a sumproduct formula