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