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

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