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