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