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. How to speed up this macro? How to use an array?
  2. Split sheet to different files - variable number of rows
  3. Solved: sort data on cell by value order
  4. Solved: Find and Replace not working
  5. click and move
  6. Applying code to entire column
  7. Simple multiplication
  8. Loop until found / user cancels
  9. Solved: Adding another code the original VBA code (Excel 2003)
  10. Export to text file
  11. Macro to combine output of two sheet into one
  12. Speed up a slow code
  13. serial search
  14. Foreign language
  15. Solved: Trying to create a text box in word from excel
  16. Reading/writing MP3 properties with Excel VBA
  17. Excel Calender
  18. Add the file name in the header of the PDF
  19. CrePivot Table To Show All Value/Field Columns
  20. Solved: Updating Data Multipage 2 to Page 1 Combo box
  21. Sort By Value In Cell
  22. Solved: Average if
  23. Shortening VB Code
  24. Merging Cell EntireRow.Insert Excel 2003
  25. Merge all data in 1 cell with format
  26. VBA email - MERGE addresses
  27. VB Code help on Worksheets
  28. Import specific cells from a website table
  29. how to write a vba code to perform complex calculations
  30. Solved: where to put end if
  31. compile error
  32. Paste the file names in a excel sheet
  33. Sumif for text + concatenation
  34. VBA pulling data from a table
  35. [SOLVED:] Condtional format but if Cell next displays "Y", conditional colour should Green
  36. Solved: Conditional Formatting Help excel 2003
  37. Solved: Run a macro by refernce to a cell
  38. PasteSpecial
  39. Search in every column for a value in a specific row, then insert a column before IF
  40. [SOLVED:] FindNext
  41. Solved: Run code when workbook opens
  42. Filling Arrays
  43. Find all possible paths in a Flowchart
  44. Comparison
  45. Solved: Referencing objects
  46. Solved: Select the last used row in a column using VBA
  47. Dates
  48. Excel 2010 VBA Insert new row changes formula
  49. Need Macro to create a Format
  50. Solved: locked method of range failed
  51. How to save webpage as html to drive
  52. [SOLVED:] UserForm Radio Buttons
  53. Create blank lines between all current
  54. VBA AND XML
  55. Copy data to Master file from Different Sheets
  56. VBA for Dynamic source data for charts
  57. 3 pairs of If and end if
  58. add message to macro
  59. auto populate with cell change event?
  60. Excel Phonebook
  61. [SOLVED:] Hiding multiple non-contiguous rows simultaneously and quickly
  62. Solved: Fine Tuning an Application Event
  63. [SOLVED:] Formula In Entire COlumn
  64. Understanding brettdj multiple goal seek code
  65. Solved: Cell Name as a variable to feed
  66. [SOLVED:] Highlight row based on cell value
  67. run Time error '76 -looking for files within Sharepoint
  68. [SOLVED:] Using array and column data to creat new sheets
  69. Converting Access SQL to EXCEL SQL
  70. [SOLVED:] NOVICE QUESTION: Referencing Integer Arrays
  71. Solved: Excel Functions VBA
  72. search and count values
  73. auto select
  74. [SOLVED:] Hide and Unhide rows based on the condition set
  75. [SOLVED:] backup of file with date
  76. [SOLVED:] Borders on a Range of Cells
  77. [SOLVED:] Multiplying cells in a range only if they have content
  78. Macro - transpose - audit
  79. formula copy
  80. [SOLVED:] Worksheet event does nothing
  81. Solved: vbs creates .xml from folders - how to run excel macro at end
  82. Solved: Avoid Screen flickering and selection
  83. cell blinking
  84. Solved: Inserting a formula with VBA
  85. Hidden ActiveX Controls Disappearing
  86. Arrange Images relative to each other
  87. Question about Slicers
  88. [SOLVED:] Make text in a cell bold
  89. Solved: VBA Code help.
  90. Find and Replace of Formula Result
  91. pivot table automation
  92. extract data from multiples excel files
  93. unable to set focus
  94. userform combobox requirement
  95. Solved: Delete Unused rows in a table
  96. VB ClearContents if add-on (Excel 2003)
  97. Solved: Save as and File Directory
  98. Solved: Create Monthly Calendar using Userform
  99. Converting conditional format to permanent and reference to shapes
  100. Solved: Writing data from workbook to text file
  101. Array function
  102. Real challenge from my professor
  103. VBA drop down and he internet
  104. Excel 2010 fuzzy vlookup add in
  105. Assign Keyboard Shortcut to Ribbon Item Excel 2007
  106. Next and Prev. command
  107. need help with a code
  108. improving class modules with syntax sugar
  109. Solved: Delete Empty cells with condition
  110. match or vlookup help
  111. Dont Change Folder/Zip File after Zipping & Unzipping
  112. Transpose Range on Key
  113. [SLEEPER:] ListBox Index Select
  114. expired workbook
  115. Solved: Producing multiple spreadsheets by running data from excel database
  116. Solved: copy data to another spreadsheet
  117. [SOLVED:] Interchanging data on different sheets
  118. Assigning macro to print button code help
  119. Solved: whats the difference
  120. Calculate Correlations Based on Changing Parameters
  121. Plotting an arrow in excel using VBA
  122. Frequently bought together
  123. Cell copy the data to another cell with offset
  124. Solved: UF Count Tally
  125. Error using .Find across worksheets
  126. insert row above button (retrieve position of button)
  127. How to analyze and sort data using VBA
  128. pause and continue
  129. Help with Excel & Office Web Component!!
  130. Solved: Open Txt File and Copy data
  131. Write Hebrew characters to file in VBA
  132. Problem with OnAction
  133. The active cell in a sheet other than the active sheet (VBA Excel)
  134. Pesky users, causing issues with userform
  135. Solved: Help with Pivot Tables
  136. Solved: Extend Range selection Down
  137. Look up values through hierarchies
  138. Solved: Find Last Used Cell In a Table
  139. sumproduct help ..
  140. Solved: Find a string and align left
  141. Data Validation List
  142. Workbook Parameters compare
  143. [SLEEPER:] OnTime Problem ..?
  144. Solved: Looking for a more 'flexible' Match()
  145. Error when set value to an worksheet object
  146. Date Tranformation
  147. sum of mismatch records
  148. Problem in adding record using macro
  149. Solved: merge blank record in first column
  150. Shade Weekends in Calendar
  151. Solved: Find final Row In Mearge TOP Cell
  152. Unselect missing line in "References VBAProject"
  153. [SOLVED:] How to stop a specific VBA loop??
  154. Solved: Option Buttons in Multipage Form
  155. VB+Excel help
  156. Solved: Choose a folder in a directory if found.
  157. Adding Data Rows into excel using user inputs.
  158. Add value in empty cell always same line column after column
  159. Count of distributors based on criteria
  160. Worksheet_BeforeDoubleClick is not invoked
  161. Solved: Modify Copy to spreadsheet
  162. Autoupdate Dropbox Values
  163. I feel Computer Illeterate
  164. Sleeper: Select column and row(s) and change format
  165. Check Box Issue
  166. Recall data to my userform
  167. populate combobox when workbook is open
  168. Date and time calculation
  169. VBA to logon to Webpage (JSP)?
  170. Import data from website
  171. Combine Data that obviously the same
  172. [SOLVED:] Quintiles and Conditional Formatting
  173. Solved: Trim extra characters from Column F
  174. Solved: SumProduct Help
  175. [SLEEPER:] Error of Advanced filter, copy & paste from different worksheets using 1 cmd button
  176. Solved: Using ElseIF
  177. Force user to enable macros
  178. Solved: Blank cells
  179. Solved: More on SumProduct
  180. Solved: Expression not running all the way through
  181. Solved: Paste block of data into certain cells
  182. Allow Group/Ungroup on protected sheet
  183. change the (Worksheet_Change) event for a module (Sub).
  184. Solved: Need help with adding yes/no msgbox to Find Procedure
  185. edit values of a cell through textbox in a user form
  186. Solved: color
  187. replace text/integer within a formula
  188. Solved: Excel VBA Code for higlighting Pass Or Fail profile
  189. Locking Cells
  190. Solved: Macro embedded in workbook
  191. Formatting not alligning properly on macro run
  192. Solved: Delete Duplicate Colums
  193. How to go through a list on two different worksheets comparing values using VBA
  194. [SOLVED:] Delete all rows under a group
  195. COUNTIF formula with text color
  196. Solved: excel can't calculate formula
  197. VBA Print Range
  198. [SLEEPER:] Obtaining the standard deviation of a range in vba code
  199. Updating Linked Data
  200. Solved: Sheet Protection and Clipboard
  201. Edit macro to pull from column instead of line in macro
  202. Close messages
  203. Extract missing digits
  204. Lookup and Match data
  205. Comparing spreadsheet - VBA almost working..
  206. [SOLVED:] Deploying Add-in
  207. Show / Hide part of Tabstrip or Multipage
  208. ActiveCell.Offset in a Data filtered sheet
  209. More Robust Directory List Generator?
  210. need help with simple macros
  211. copy cells to one page from others
  212. Same ComboBox Value to show in 3 other ComboBoxes in Seperate Userforms
  213. How to disable Paste Special->Keep Source Formatting - Excel 2010
  214. Collecting Data
  215. [SOLVED:] Close and re-open
  216. userform combobox error
  217. Use PlaySound and control left/right volume independently
  218. VBA Code to copy required data into Separate Sheet
  219. Sum x number of rows
  220. Minimise use of SELECT in macro copying data from one sheet to another
  221. Extract substring
  222. Solved: if-else query
  223. Solved: problem with sum product formula
  224. Auto Email
  225. Solved: How to perform code on all pages except first one
  226. Multiple columns into multiple rows
  227. read write format text files
  228. sort by upcoming date 60 days from today
  229. Solved: combine data from spreadsheet help
  230. find number of work days in month
  231. Remove Duplicates by Date Range
  232. Store Value in A temporary Variable
  233. Solved: Search Through Subfolders of a Selected Folder
  234. Solved: Creating folder with drive selection.
  235. split workbook into 2 by criteria
  236. Find Function - ONLY find what is specified
  237. Solved: Using Dir()
  238. Solved: Formula to extract string help
  239. Solved: Convert formula to Macro; find closest value and return adjacent values
  240. Error in Picking the specific excel file
  241. Formatting a cell's value as a date
  242. VBA overflow problem, export data
  243. Fill Rows Based On Cell Above
  244. Delete Row If Cell Doesn't Contain Word
  245. Formula Help
  246. Copy data from Multiple Sheets
  247. [SOLVED:] Merge multiple .txt files into one .txt thru Excel VBA
  248. [SOLVED:] Hyperlinking photos from directory
  249. Create Sheet
  250. export word tables into excel