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