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

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