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