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

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