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

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