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. VBA to view QT Connection String
  2. VBA excel 2011 save as PDF
  3. Macro showing various errors in my code for charts.
  4. Excel Page Format-help pls.
  5. Worksheet Security based on Windows ID
  6. Auto-filter turning off in protected worksheet
  7. Find Times Greater than Time Entered
  8. Retrieve Values through an RS232 Connection
  9. VBA - Setting Pivot Chart height at pivot table refresh
  10. Macro for hidding and unhidding sheets
  11. Solved: how to copy range and paste in same range in another workbook
  12. Pop Up Message Keeps popping up
  13. Solved: Application or Object defined error
  14. Solved: populate with range from another sheet
  15. Find the Double ID
  16. Closed workbook and extract sheet by cell value
  17. Solved: msgbox displaying new workbook object path
  18. Conditional formatting according to range
  19. Retreiving the properties out of a class.
  20. fill Combo box data acroding to text box data entry.
  21. Solved: Loop Help
  22. Multiple LIKE operators?
  23. Solved: help getting listindex from listbox
  24. Open Workbook transfer info then close workbook (2007)
  25. [SOLVED] Many urgent excel at vertical instead of horizontal word
  26. Compare two worksheets and give the difference as result
  27. Input box to select sheet then rename sheet
  28. To get in Excel the URL of the opened Webpage ?
  29. Array raising each element to a power - please help!
  30. Split Data in one cell into below rows
  31. Copying and pasting cells from Excel to a fillable PDF file
  32. Sort duplicates on top
  33. Help getting script to exit if cell is blank
  34. Solved: Dynamically setting a dropdown dependant upon cell value
  35. VBA with PI Datalink
  36. Macro doesn’t work after a table is created.
  37. To paste in Word the selected text in webpage by an Excel macro
  38. Adding MMM-YY to filename
  39. Combine multiple rows into one and then seprate specific columns
  40. Solved: VBA Copy a template sheet and paste it into multiple sheets
  41. Something odd has happened with an "Always on Top" window.
  42. [SOLVED] 3 cells USERFORM to enroll in one cell in excel
  43. Solved: Converting the VB code to VBA.
  44. Total values associated with unique value in adjacent column
  45. VBA HELP! - Need slight change to my code
  46. VBA pivot with no range
  47. Drop Down List to Copy Contents of Another Column into a Certain Column
  48. VBA Help - Desk sharing solution - thanks in advance
  49. How to post sample excel data
  50. Solved: run macro from one workbok to affect other workbook
  51. Solved: code running too fast?
  52. Change Dropdown Macro
  53. Find all hard coded references
  54. Master Directory Search (Needs A Tweak)
  55. VBA from Excel to Outlook 2010 help
  56. Solved: CAGR formula using only range as input
  57. Synchronizing Multiple Worksheets
  58. Solved: function to find the number of iterations/loops Do...Loop
  59. Solved: Dynamically populate combobox in userform
  60. Accessing files in order of Date Last modified
  61. Solved: Loop through multiple sheets and delete rows based on a cell reference
  62. Project locked for viewing - SendKeys?
  63. Excel 2 XML using Macro
  64. Macro is getting Runtime error 91 - why?
  65. Macro Triggers Unreadable Content Error on Restart
  66. Sleeper: Macro loop issues
  67. Solved: Detecting Last Time File Was Opened
  68. Solved: Opening and writing to multiple ASCII text files
  69. find closest date
  70. Solved: Calculate Distribution
  71. Save as xlsm function
  72. Getting Application defined error 1004 for vba
  73. FileSystemObject create file containing text copied from IE
  74. Solved: Stop watch in excel which just displays minutes
  75. Insert and Delete Rows in Entire Workbook
  76. Reference across sheets
  77. Worksheet on change code a bit slow
  78. Can somebody help to achieve following tasks?
  79. Solved: Command Button (Save as PDF)
  80. How to copy an active Excel worksheet to another excel file?
  81. Using conditional formatting
  82. getting the row numbers of visible rows in an filtered selection
  83. simple auto macro :)
  84. Copying sheets into new workbook
  85. How to create a sequence of dates?
  86. VB disable conditional formatting code
  87. Determining the 2nd highest number in a list
  88. Solved: update pivot tables based on the value of cell 'C2'
  89. Real Time Clock in a Textbox on a Userform
  90. alphanumerics only
  91. Macro to import entire text file into single cell
  92. Simple Merge of two lists/tables
  93. [SOLVED] Index/Match VBA equivalent to append data
  94. Solved: How to suppress replacing cells when using PasteSpecial?
  95. Solved: Populate hyphen for continuous three or more zero in a row
  96. Sleeper: vba program
  97. Solved: Delete Duplicate Values only... Not rows
  98. Solved: Creating a dynamic user defined function
  99. Filter a sheet and copy results to another sheet
  100. date range and return value
  101. Solved: Fill an array with vlookup vba
  102. shade header row
  103. Conditional Formatting - Change font
  104. Paste onto filtered cells
  105. Solved: VBA Interaction with IE
  106. modify macro with hyperlink
  107. Moving Files Based on Last Modified Date
  108. Solved: Creating a dynamic concatenation from a list
  109. What is the code to open access file
  110. Troubleshoot an Overflow Error
  111. Passing transformed arguments to UDF
  112. Solved: Automatically Update date in cell value if workbook is saved under a different name.
  113. MyCheck Fuction
  114. Sumdata based on a table of possible criteria
  115. Solved: error with mouse_down
  116. How to enumerate a variant array?
  117. Excel WB painfully slow
  118. Solved: Error found in codes given in KB
  119. Solved: Copy From Multiple Files To One
  120. Solved: Email active worksheet using Outlook
  121. GOBACK subroutine for Excel 2007
  122. Solved: Identifying Duplicates Prior to Data Entry.
  123. Solved: Copy, Open, Paste
  124. Solved: Add Hairline Border Via Vb
  125. Excel using Loop
  126. Solved: VBA table summarize
  127. Populate Two Text Box using input value
  128. 'Partial' Julian Date Issue
  129. Windows Explorer Shortcut Link Generator
  130. Conditional Format On Specific Range
  131. Filtered Cells Problem
  132. Remove last few characters from a string
  133. xmlHttp get requst - cannot get past login
  134. How to control an Excel file without opening it?
  135. XML Integration
  136. Solved: Locate Date in cell formatted as DD-MMM
  137. FileName
  138. "method range of object _worksheet failed" Error
  139. get data from word form into excel using macro
  140. Solved: creating multiple xltx templates
  141. Formula to pull formula from another cell
  142. Solved: insert row if match is missing in column above
  143. Solved: Populating Textbox 2 on the basis of Textbox 1
  144. MACRO help to delete some files in a particular folder
  145. Login and Password for user form
  146. Create Workbooks based on Unique Values from a Column
  147. Code running amazing slow when file is shared
  148. Loop? Copy/Paste from to Summary from Workbooks on Server
  149. Solved: Find Question
  150. Search Functionality that moves cursor
  151. Solved: Hide Rows...help in code
  152. Concatenate (Nest) "IF" Commands ??
  153. Syntax for Set_Cursor_Pos()
  154. Search Worksheet for Name if found copy to new workbook
  155. Compare data between two workbooks
  156. Excel code to open Access!
  157. Source workbook keeps opening when Destination workbook is protected?
  158. Need to increase the percentage in a cell containing the original value
  159. Storing Variable From One Cell And Printing It Repetitively In Another Column
  160. Solved: Change color figures, with discretion
  161. Thematic Map
  162. show username if file is open
  163. Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest
  164. Loop through rows and delete/keep
  165. Printing Unique Values (From a column) in a Combobox
  166. Modify Cut Paste
  167. Help with concatrelated vba excel
  168. Printing issue
  169. Solved: cut and pasted into Sheet2
  170. A Combo Box for Certain Types of Information from another worksheet??
  171. Solved: Copy Range If Cell Value Equals
  172. Highlight the last selected cell
  173. Solved: Problem in creating status bar
  174. VBA functionality for String manipulation
  175. use date stamp to trigger Shift:=xlDown?
  176. Calculation On/OFF Basis On Selection
  177. Sum amounts based on another column
  178. Solved: Select the shape as shape variable
  179. How to solve excel compatibility?
  180. Solved: Do something every 14 minutes
  181. Solved: VBA Formatting mess of text
  182. Open Notepad and write something onto it
  183. Passing an Object to a Function
  184. auto save and close workbook after 15 minutes of inactivity
  185. Loop filter and copy
  186. Getting data from Word Controls into Excel
  187. Solved: SumProduct RowsandColumns
  188. Populating IP Address & Username of the user in Excel
  189. Question on ActiveWorkbook.Calculate
  190. Copying range to variant
  191. Solved: Runtime error '13', Type Mismatch
  192. Formatting excel sheet
  193. Disable File Save And Highlight Empty Cells
  194. Solved: automatic FormulaCalculation Option using VBA
  195. Help VBA code for calculating time difference
  196. Solved: vary column
  197. Nested loops and populating a new ws with the items
  198. Merging two or more files, column by column
  199. Compare two worksheet current code modification
  200. auto Email
  201. Data transfer based on certain findings
  202. editing text in a cell
  203. Send Excel Body by Outlook
  204. Excel VBA Error 445 in 2007/10 but 2003 is fine
  205. Same number of trades
  206. Count members of AD group from Excel
  207. Play Sound in Excel
  208. Highlighting particular cells
  209. Solved: Workbook Slowdown
  210. Plotting to PDF
  211. Sort Values In Array
  212. [SOLVED] File Renaming Tool - Working in Subfolders
  213. Solved: Change in Path to Server - Query Macros Affected
  214. Sine Wave Audio Sound Generator
  215. Solved: Pivot Date Filter between variable number of days
  216. Problem with keeping the year end dates of downloaded financial data
  217. Solved: Locking a Row Question
  218. Nested IF Function not working when the first condition is False
  219. Help please want to write string sorting function
  220. Solved: count, insert, copy, paste rows from one worksheet to another
  221. Application.MacroOptions: StatusBar property not working
  222. Need help on MultiPage control
  223. Solved: Advice and Help which database to use
  224. combine all file in a one workbook
  225. Excel 2007
  226. Read/Write Userform to variable range of cells
  227. Highlight the selected cell
  228. Private Sub : copy formula
  229. Madness - Excel Crashing
  230. If Statement checking
  231. Searching multiple workbooks for hidden content
  232. Solved: Copy B4 value of each guide based on column A of worksheet "Plan2"
  233. Solved: Copy and Paste Row if Cell Has Value
  234. Filter : date after 15 /10/2012
  235. excel pivot table problem
  236. Code doesn't send in email
  237. VBA merge from some open and some closed workbooks
  238. Selecting 2 Cells to the right of the ActiveCell
  239. Copying Excel range to Word doesn't copy the image
  240. Solved: Inserting data into the column and maintain it locked
  241. Scroll to a named macro in the VBE
  242. Solved: Dynamic array in VBA of newly added worksheets
  243. Solved: Vba code to clear data cells only not those with formula
  244. Add value, as seconds, to LongDate
  245. Generating Custom Report thru VBA
  246. Solved: Copy formula automatically & Paste valuse :VBA code error Rectification
  247. vba workbook_sheetchange event for xlam thisworkbook
  248. Run HLOOKUP macro on outcome of Data Validation
  249. Application defined or Object defined error
  250. Choose range